4.0.1 • Published 2 months ago

@sprucelabs/jest-sheets-reporter v4.0.1

Weekly downloads
790
License
-
Repository
-
Last release
2 months ago

Google Sheets Reporter

Update a Google Sheet when your tests pass or fail.

Installing

yarn add -D @sprucelabs/jest-sheets-reporter
npm install --dev @sprucelabs/jest-sheets-reporter

Example Jest config

Inside your package.json there is a jest block.

Add the following configuration:

"jest": {
    "reporters": [
        "default",
        [
            "@sprucelabs/jest-sheets-reporter",
            {
                "sheetId": "{{spreadsheetId}}",
                "worksheetId": 0,
                "testMap": {
                    "testName": "destinationCell",
                    "getsGoodHealthCheckAndNothingElse": "C5",
                    "canGetLatestVersionBasedOnDir": "C16",
                    "canBuildSkill": "C24",
                    "canWatchAndBuild": "C25"
                }
            }
        ]
    ]
},

How does it work

This simple reporter matches the name of your test against what is in your jest config and updates the cell whose name matches.

If a test passes, the cell is set to 1.

If a test fails, the cell is set to 0.

Making it pretty

You can change the look of a cell by using conditional formatting:

Then we set the background and the text color based on the value being exactly 1 or 0.

Getting your account credentials

  1. Visit the Google Console
  2. Create a new project, call it Test Integrations
  3. After creation, go to the project dashboard and in the left meno go "API's & Services" -> "Enabled API's & Services"
  4. Click "+ Enable API's and Services"
  5. Find sheets and enable it.
  6. After save, click "Create Credentials" in the upper right.
  7. Give it a name, leave everything else blank and save
  8. After save, click "Credentials" in the left menu
  9. Then click on your service account's name
  10. On the service account details page, click "KEYS" tab
  11. Click Add Key -> JSON
  12. Take the download private key and open it
  13. client_email -> GOOGLE_SERVICE_EMAIL
  14. private_key -> GOOGLE_SERVICE_PRIVATE_KEY
  15. Remember to invite the service email to any spreadsheet you want it to update!
4.0.1

2 months ago

4.0.0

2 months ago

3.0.219

4 months ago

3.0.218

4 months ago

3.0.222

3 months ago

3.0.221

4 months ago

3.0.224

3 months ago

3.0.223

3 months ago

3.0.226

2 months ago

3.0.225

2 months ago

3.0.220

4 months ago

3.0.208

5 months ago

3.0.207

6 months ago

3.0.209

5 months ago

3.0.211

5 months ago

3.0.210

5 months ago

3.0.213

5 months ago

3.0.212

5 months ago

3.0.215

5 months ago

3.0.214

5 months ago

3.0.217

4 months ago

3.0.216

4 months ago

3.0.200

7 months ago

3.0.202

6 months ago

3.0.201

6 months ago

3.0.204

6 months ago

3.0.203

6 months ago

3.0.206

6 months ago

3.0.205

6 months ago

3.0.190

8 months ago

3.0.199

7 months ago

3.0.192

8 months ago

3.0.191

8 months ago

3.0.194

8 months ago

3.0.193

8 months ago

3.0.196

8 months ago

3.0.195

8 months ago

3.0.198

7 months ago

3.0.197

8 months ago

3.0.189

8 months ago

3.0.188

8 months ago

3.0.183

9 months ago

3.0.185

9 months ago

3.0.184

9 months ago

3.0.187

9 months ago

3.0.186

9 months ago

3.0.181

9 months ago

3.0.182

9 months ago

3.0.180

9 months ago

3.0.178

9 months ago

3.0.177

9 months ago

3.0.179

9 months ago

3.0.172

9 months ago

3.0.174

9 months ago

3.0.173

9 months ago

3.0.176

9 months ago

3.0.175

9 months ago

3.0.170

9 months ago

3.0.171

9 months ago

3.0.169

9 months ago

3.0.168

9 months ago

3.0.167

9 months ago

3.0.166

9 months ago

3.0.163

9 months ago

3.0.165

9 months ago

3.0.164

9 months ago

3.0.161

10 months ago

3.0.160

10 months ago

3.0.162

10 months ago

3.0.156

10 months ago

3.0.158

10 months ago

3.0.157

10 months ago

3.0.159

10 months ago

3.0.89

11 months ago

3.0.87

11 months ago

3.0.88

11 months ago

3.0.81

1 year ago

3.0.82

1 year ago

3.0.80

1 year ago

3.0.85

1 year ago

3.0.86

1 year ago

3.0.83

1 year ago

3.0.84

1 year ago

3.0.98

11 months ago

3.0.99

11 months ago

3.0.92

11 months ago

3.0.93

11 months ago

3.0.90

11 months ago

3.0.91

11 months ago

3.0.96

11 months ago

3.0.97

11 months ago

3.0.94

11 months ago

3.0.95

11 months ago

3.0.67

1 year ago

3.0.68

1 year ago

3.0.65

1 year ago

3.0.66

1 year ago

3.0.69

1 year ago

3.0.60

1 year ago

3.0.63

1 year ago

3.0.64

1 year ago

3.0.61

1 year ago

3.0.62

1 year ago

3.0.78

1 year ago

3.0.79

1 year ago

3.0.76

1 year ago

3.0.77

1 year ago

3.0.70

1 year ago

3.0.71

1 year ago

3.0.74

1 year ago

3.0.75

1 year ago

3.0.72

1 year ago

3.0.73

1 year ago

3.0.119

11 months ago

3.0.123

11 months ago

3.0.122

11 months ago

3.0.125

11 months ago

3.0.124

11 months ago

3.0.127

11 months ago

3.0.126

11 months ago

3.0.129

11 months ago

3.0.128

11 months ago

3.0.121

11 months ago

3.0.120

11 months ago

3.0.109

11 months ago

3.0.108

11 months ago

3.0.112

11 months ago

3.0.111

11 months ago

3.0.114

11 months ago

3.0.113

11 months ago

3.0.116

11 months ago

3.0.115

11 months ago

3.0.118

11 months ago

3.0.117

11 months ago

3.0.110

11 months ago

3.0.101

11 months ago

3.0.100

11 months ago

3.0.103

11 months ago

3.0.102

11 months ago

3.0.105

11 months ago

3.0.104

11 months ago

3.0.107

11 months ago

3.0.106

11 months ago

3.0.155

11 months ago

3.0.150

11 months ago

3.0.152

11 months ago

3.0.151

11 months ago

3.0.154

11 months ago

3.0.153

11 months ago

3.0.145

11 months ago

3.0.144

11 months ago

3.0.147

11 months ago

3.0.146

11 months ago

3.0.149

11 months ago

3.0.148

11 months ago

3.0.141

11 months ago

3.0.140

11 months ago

3.0.143

11 months ago

3.0.142

11 months ago

3.0.134

11 months ago

3.0.133

11 months ago

3.0.136

11 months ago

3.0.135

11 months ago

3.0.138

11 months ago

3.0.137

11 months ago

3.0.139

11 months ago

3.0.130

11 months ago

3.0.132

11 months ago

3.0.131

11 months ago

3.0.45

1 year ago

3.0.46

1 year ago

3.0.43

1 year ago

3.0.44

1 year ago

3.0.49

1 year ago

3.0.47

1 year ago

3.0.48

1 year ago

3.0.41

1 year ago

3.0.42

1 year ago

3.0.40

1 year ago

3.0.56

1 year ago

3.0.57

1 year ago

3.0.54

1 year ago

3.0.55

1 year ago

3.0.58

1 year ago

3.0.59

1 year ago

3.0.52

1 year ago

3.0.53

1 year ago

3.0.50

1 year ago

3.0.51

1 year ago

3.0.27

1 year ago

3.0.28

1 year ago

3.0.34

1 year ago

3.0.35

1 year ago

3.0.32

1 year ago

3.0.33

1 year ago

3.0.38

1 year ago

3.0.39

1 year ago

3.0.36

1 year ago

3.0.37

1 year ago

3.0.30

1 year ago

3.0.31

1 year ago

3.0.29

1 year ago

3.0.26

2 years ago

3.0.13

2 years ago

3.0.16

2 years ago

3.0.17

2 years ago

3.0.14

2 years ago

3.0.15

2 years ago

3.0.23

2 years ago

3.0.24

2 years ago

3.0.21

2 years ago

3.0.22

2 years ago

3.0.25

2 years ago

3.0.20

2 years ago

3.0.18

2 years ago

3.0.19

2 years ago

3.0.4

2 years ago

3.0.3

2 years ago

3.0.2

2 years ago

3.0.1

2 years ago

3.0.8

2 years ago

3.0.7

2 years ago

3.0.6

2 years ago

3.0.5

2 years ago

3.0.0

2 years ago

3.0.9

2 years ago

3.0.12

2 years ago

3.0.10

2 years ago

3.0.11

2 years ago

2.0.15

3 years ago

2.0.16

3 years ago

2.0.13

3 years ago

2.0.14

3 years ago

2.0.11

3 years ago

2.0.12

3 years ago

2.0.10

3 years ago

2.0.19

3 years ago

2.0.17

3 years ago

2.0.18

3 years ago

2.0.20

3 years ago

2.0.21

3 years ago

2.0.3

3 years ago

2.0.2

3 years ago

2.0.5

3 years ago

2.0.4

3 years ago

2.0.7

3 years ago

2.0.6

3 years ago

2.0.9

3 years ago

2.0.8

3 years ago

2.0.1

3 years ago

2.0.0

3 years ago

1.3.117

3 years ago

1.3.116

3 years ago

1.3.119

3 years ago

1.3.118

3 years ago

1.3.124

3 years ago

1.3.123

3 years ago

1.3.122

3 years ago

1.3.121

3 years ago

1.3.120

3 years ago

1.3.102

3 years ago

1.3.101

3 years ago

1.3.100

3 years ago

1.3.106

3 years ago

1.3.105

3 years ago

1.3.104

3 years ago

1.3.103

3 years ago

1.3.109

3 years ago

1.3.108

3 years ago

1.3.107

3 years ago

1.3.113

3 years ago

1.3.112

3 years ago

1.3.111

3 years ago

1.3.110

3 years ago

1.3.115

3 years ago

1.3.114

3 years ago

1.3.90

3 years ago

1.3.93

3 years ago

1.3.94

3 years ago

1.3.91

3 years ago

1.3.92

3 years ago

1.3.97

3 years ago

1.3.98

3 years ago

1.3.95

3 years ago

1.3.96

3 years ago

1.3.99

3 years ago

1.3.87

3 years ago

1.3.88

3 years ago

1.3.89

3 years ago

1.3.82

3 years ago

1.3.83

3 years ago

1.3.86

3 years ago

1.3.84

3 years ago

1.3.85

3 years ago

1.3.50

3 years ago

1.3.53

3 years ago

1.3.54

3 years ago

1.3.51

3 years ago

1.3.52

3 years ago

1.3.57

3 years ago

1.3.58

3 years ago

1.3.55

3 years ago

1.3.56

3 years ago

1.3.59

3 years ago

1.3.60

3 years ago

1.3.61

3 years ago

1.3.64

3 years ago

1.3.65

3 years ago

1.3.62

3 years ago

1.3.63

3 years ago

1.3.68

3 years ago

1.3.69

3 years ago

1.3.66

3 years ago

1.3.67

3 years ago

1.3.47

3 years ago

1.3.48

3 years ago

1.3.49

3 years ago

1.3.71

3 years ago

1.3.72

3 years ago

1.3.70

3 years ago

1.3.75

3 years ago

1.3.76

3 years ago

1.3.73

3 years ago

1.3.74

3 years ago

1.3.79

3 years ago

1.3.77

3 years ago

1.3.78

3 years ago

1.3.80

3 years ago

1.3.81

3 years ago

1.3.46

3 years ago

1.3.44

3 years ago

1.3.45

3 years ago

1.3.39

3 years ago

1.3.42

3 years ago

1.3.43

3 years ago

1.3.40

3 years ago

1.3.41

3 years ago

1.3.38

3 years ago

1.3.36

3 years ago

1.3.37

3 years ago

1.3.31

3 years ago

1.3.32

3 years ago

1.3.30

3 years ago

1.3.35

3 years ago

1.3.33

3 years ago

1.3.34

3 years ago

1.3.24

3 years ago

1.3.25

3 years ago

1.3.28

3 years ago

1.3.29

3 years ago

1.3.26

3 years ago

1.3.27

3 years ago

1.3.17

3 years ago

1.3.18

3 years ago

1.3.19

3 years ago

1.3.20

3 years ago

1.3.21

3 years ago

1.3.22

3 years ago

1.3.23

3 years ago

1.3.10

3 years ago

1.3.13

3 years ago

1.3.14

3 years ago

1.3.11

3 years ago

1.3.12

3 years ago

1.3.15

3 years ago

1.3.16

3 years ago

1.3.7

3 years ago

1.3.6

3 years ago

1.3.5

3 years ago

1.3.4

3 years ago

1.3.3

3 years ago

1.3.2

3 years ago

1.3.1

3 years ago

1.3.0

3 years ago

1.2.301

4 years ago

1.2.300

4 years ago

1.2.303

4 years ago

1.2.302

4 years ago

1.2.305

4 years ago

1.2.304

4 years ago

1.3.9

3 years ago

1.3.8

3 years ago

1.2.310

4 years ago

1.2.312

4 years ago

1.2.311

4 years ago

1.2.314

4 years ago

1.2.313

4 years ago

1.2.316

4 years ago

1.2.315

4 years ago

1.2.307

4 years ago

1.2.306

4 years ago

1.2.309

4 years ago

1.2.308

4 years ago

1.2.318

4 years ago

1.2.317

4 years ago

1.2.319

4 years ago

1.2.299

4 years ago

1.2.298

4 years ago

1.2.293

4 years ago

1.2.295

4 years ago

1.2.294

4 years ago

1.2.297

4 years ago

1.2.296

4 years ago

1.2.255

4 years ago

1.2.254

4 years ago

1.2.257

4 years ago

1.2.256

4 years ago

1.2.259

4 years ago

1.2.258

4 years ago

1.2.251

4 years ago

1.2.250

4 years ago

1.2.253

4 years ago

1.2.252

4 years ago

1.2.266

4 years ago

1.2.265

4 years ago

1.2.268

4 years ago

1.2.267

4 years ago

1.2.269

4 years ago

1.2.260

4 years ago

1.2.262

4 years ago

1.2.261

4 years ago

1.2.264

4 years ago

1.2.263

4 years ago

1.2.277

4 years ago

1.2.276

4 years ago

1.2.279

4 years ago

1.2.278

4 years ago

1.2.271

4 years ago

1.2.270

4 years ago

1.2.273

4 years ago

1.2.272

4 years ago

1.2.275

4 years ago

1.2.274

4 years ago

1.2.288

4 years ago

1.2.287

4 years ago

1.2.289

4 years ago

1.2.280

4 years ago

1.2.282

4 years ago

1.2.281

4 years ago

1.2.284

4 years ago

1.2.283

4 years ago

1.2.286

4 years ago

1.2.285

4 years ago

1.2.237

4 years ago

1.2.239

4 years ago

1.2.238

4 years ago

1.2.244

4 years ago

1.2.243

4 years ago

1.2.246

4 years ago

1.2.245

4 years ago

1.2.248

4 years ago

1.2.247

4 years ago

1.2.249

4 years ago

1.2.240

4 years ago

1.2.242

4 years ago

1.2.241

4 years ago

1.2.291

4 years ago

1.2.290

4 years ago

1.2.292

4 years ago

1.2.235

4 years ago

1.2.236

4 years ago

1.2.233

4 years ago

1.2.234

4 years ago

1.2.232

4 years ago

1.2.231

4 years ago

1.2.211

4 years ago

1.2.210

4 years ago

1.2.213

4 years ago

1.2.212

4 years ago

1.2.215

4 years ago

1.2.214

4 years ago

1.2.217

4 years ago

1.2.216

4 years ago

1.2.208

4 years ago

1.2.207

4 years ago

1.2.209

4 years ago

1.2.222

4 years ago

1.2.221

4 years ago

1.2.224

4 years ago

1.2.223

4 years ago

1.2.226

4 years ago

1.2.225

4 years ago

1.2.228

4 years ago

1.2.227

4 years ago

1.2.220

4 years ago

1.2.219

4 years ago

1.2.218

4 years ago

1.2.230

4 years ago

1.2.229

4 years ago

1.2.202

4 years ago

1.2.204

4 years ago

1.2.203

4 years ago

1.2.206

4 years ago

1.2.205

4 years ago

1.2.200

4 years ago

1.2.201

4 years ago

1.2.189

4 years ago

1.2.188

4 years ago

1.2.185

4 years ago

1.2.187

4 years ago

1.2.186

4 years ago

1.2.199

4 years ago

1.2.192

4 years ago

1.2.191

4 years ago

1.2.194

4 years ago

1.2.193

4 years ago

1.2.196

4 years ago

1.2.195

4 years ago

1.2.198

4 years ago

1.2.197

4 years ago

1.2.190

4 years ago

1.2.169

4 years ago

1.2.178

4 years ago

1.2.177

4 years ago

1.2.179

4 years ago

1.2.170

4 years ago

1.2.172

4 years ago

1.2.171

4 years ago

1.2.174

4 years ago

1.2.173

4 years ago

1.2.176

4 years ago

1.2.175

4 years ago

1.2.181

4 years ago

1.2.180

4 years ago

1.2.183

4 years ago

1.2.182

4 years ago

1.2.184

4 years ago

1.2.134

4 years ago

1.2.133

4 years ago

1.2.136

4 years ago

1.2.135

4 years ago

1.2.138

4 years ago

1.2.137

4 years ago

1.2.139

4 years ago

1.2.130

4 years ago

1.2.132

4 years ago

1.2.131

4 years ago

1.2.145

4 years ago

1.2.144

4 years ago

1.2.147

4 years ago

1.2.146

4 years ago

1.2.149

4 years ago

1.2.148

4 years ago

1.2.141

4 years ago

1.2.140

4 years ago

1.2.143

4 years ago

1.2.142

4 years ago

1.2.156

4 years ago

1.2.155

4 years ago

1.2.158

4 years ago

1.2.157

4 years ago

1.2.159

4 years ago

1.2.150

4 years ago

1.2.152

4 years ago

1.2.151

4 years ago

1.2.154

4 years ago

1.2.153

4 years ago

1.2.167

4 years ago

1.2.166

4 years ago

1.2.168

4 years ago

1.2.161

4 years ago

1.2.160

4 years ago

1.2.163

4 years ago

1.2.162

4 years ago

1.2.165

4 years ago

1.2.164

4 years ago

1.2.112

4 years ago

1.2.111

4 years ago

1.2.114

4 years ago

1.2.113

4 years ago

1.2.116

4 years ago

1.2.115

4 years ago

1.2.118

4 years ago

1.2.117

4 years ago

1.2.123

4 years ago

1.2.122

4 years ago

1.2.125

4 years ago

1.2.124

4 years ago

1.2.127

4 years ago

1.2.126

4 years ago

1.2.129

4 years ago

1.2.128

4 years ago

1.2.121

4 years ago

1.2.120

4 years ago

1.2.119

4 years ago

1.2.97

4 years ago

1.2.98

4 years ago

1.2.99

4 years ago

1.2.101

4 years ago

1.2.100

4 years ago

1.2.103

4 years ago

1.2.102

4 years ago

1.2.105

4 years ago

1.2.104

4 years ago

1.2.107

4 years ago

1.2.106

4 years ago

1.2.110

4 years ago

1.2.109

4 years ago

1.2.108

4 years ago

1.2.92

4 years ago

1.2.93

4 years ago

1.2.96

4 years ago

1.2.94

4 years ago

1.2.95

4 years ago

1.2.89

4 years ago

1.2.90

4 years ago

1.2.91

4 years ago

1.2.86

4 years ago

1.2.87

4 years ago

1.2.88

4 years ago

1.2.82

4 years ago

1.2.85

4 years ago

1.2.83

4 years ago

1.2.84

4 years ago

1.2.81

4 years ago

1.2.80

4 years ago

1.2.78

4 years ago

1.2.79

4 years ago

1.2.77

4 years ago

1.2.76

4 years ago

1.2.75

4 years ago

1.2.70

4 years ago

1.2.71

4 years ago

1.2.74

4 years ago

1.2.72

4 years ago

1.2.73

4 years ago

1.2.67

4 years ago

1.2.68

4 years ago

1.2.66

4 years ago

1.2.69

4 years ago

1.2.65

4 years ago

1.2.63

4 years ago

1.2.64

4 years ago

1.2.60

4 years ago

1.2.61

4 years ago

1.2.62

4 years ago

1.2.58

4 years ago

1.2.59

4 years ago

1.2.57

4 years ago

1.2.56

4 years ago

1.2.54

4 years ago

1.2.55

4 years ago

1.2.53

4 years ago

1.2.52

4 years ago

1.2.50

4 years ago

1.2.51

4 years ago

1.2.49

4 years ago

1.2.47

4 years ago

1.2.48

4 years ago

1.2.46

4 years ago

1.2.45

4 years ago

1.2.44

4 years ago

1.2.43

4 years ago

1.2.42

4 years ago

1.2.41

4 years ago

1.2.40

4 years ago

1.2.39

4 years ago

1.2.38

4 years ago

1.2.37

4 years ago

1.2.23

4 years ago

1.2.22

4 years ago

1.2.21

4 years ago

1.2.20

4 years ago

1.2.19

4 years ago

1.2.18

4 years ago

1.2.17

4 years ago

1.2.16

4 years ago

1.2.15

4 years ago

1.2.14

4 years ago

1.2.13

4 years ago

1.2.12

4 years ago

1.2.11

4 years ago

1.2.10

4 years ago

1.2.9

5 years ago

1.2.8

5 years ago

1.2.7

5 years ago

1.2.6

5 years ago

1.2.5

5 years ago

1.2.4

5 years ago

1.2.3

5 years ago

1.2.2

5 years ago

1.2.1

5 years ago

1.2.0

5 years ago

1.1.2

5 years ago

1.1.1

5 years ago

1.1.0

5 years ago

1.0.0

5 years ago