4.0.1 • Published 3 months ago

@sprucelabs/jest-sheets-reporter v4.0.1

Weekly downloads
790
License
-
Repository
-
Last release
3 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!
nodecomponentssprucebotsprucelabs
dotenvgoogle-spreadsheetretry
@infinitebrahmanuniverse/nolb-_spr@everything-registry/sub-chunk-860@zalastax/nolb-_spr
4.0.1

3 months ago

4.0.0

3 months ago

3.0.219

6 months ago

3.0.218

6 months ago

3.0.222

5 months ago

3.0.221

5 months ago

3.0.224

4 months ago

3.0.223

4 months ago

3.0.226

4 months ago

3.0.225

4 months ago

3.0.220

5 months ago

3.0.208

7 months ago

3.0.207

7 months ago

3.0.209

7 months ago

3.0.211

7 months ago

3.0.210

7 months ago

3.0.213

6 months ago

3.0.212

6 months ago

3.0.215

6 months ago

3.0.214

6 months ago

3.0.217

6 months ago

3.0.216

6 months ago

3.0.200

8 months ago

3.0.202

8 months ago

3.0.201

8 months ago

3.0.204

7 months ago

3.0.203

8 months ago

3.0.206

7 months ago

3.0.205

7 months ago

3.0.190

10 months ago

3.0.199

8 months ago

3.0.192

10 months ago

3.0.191

10 months ago

3.0.194

9 months ago

3.0.193

10 months ago

3.0.196

9 months ago

3.0.195

9 months ago

3.0.198

8 months ago

3.0.197

9 months ago

3.0.189

10 months ago

3.0.188

10 months ago

3.0.183

10 months ago

3.0.185

10 months ago

3.0.184

10 months ago

3.0.187

10 months ago

3.0.186

10 months ago

3.0.181

11 months ago

3.0.182

11 months ago

3.0.180

11 months ago

3.0.178

11 months ago

3.0.177

11 months ago

3.0.179

11 months ago

3.0.172

11 months ago

3.0.174

11 months ago

3.0.173

11 months ago

3.0.176

11 months ago

3.0.175

11 months ago

3.0.170

11 months ago

3.0.171

11 months ago

3.0.169

11 months ago

3.0.168

11 months ago

3.0.167

11 months ago

3.0.166

11 months ago

3.0.163

11 months ago

3.0.165

11 months ago

3.0.164

11 months ago

3.0.161

11 months ago

3.0.160

11 months ago

3.0.162

11 months ago

3.0.156

11 months ago

3.0.158

11 months ago

3.0.157

11 months ago

3.0.159

11 months ago

3.0.89

1 year ago

3.0.87

1 year ago

3.0.88

1 year 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

1 year ago

3.0.99

1 year ago

3.0.92

1 year ago

3.0.93

1 year ago

3.0.90

1 year ago

3.0.91

1 year ago

3.0.96

1 year ago

3.0.97

1 year ago

3.0.94

1 year ago

3.0.95

1 year 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

1 year ago

3.0.123

1 year ago

3.0.122

1 year ago

3.0.125

1 year ago

3.0.124

1 year ago

3.0.127

1 year ago

3.0.126

1 year ago

3.0.129

1 year ago

3.0.128

1 year ago

3.0.121

1 year ago

3.0.120

1 year ago

3.0.109

1 year ago

3.0.108

1 year ago

3.0.112

1 year ago

3.0.111

1 year ago

3.0.114

1 year ago

3.0.113

1 year ago

3.0.116

1 year ago

3.0.115

1 year ago

3.0.118

1 year ago

3.0.117

1 year ago

3.0.110

1 year ago

3.0.101

1 year ago

3.0.100

1 year ago

3.0.103

1 year ago

3.0.102

1 year ago

3.0.105

1 year ago

3.0.104

1 year ago

3.0.107

1 year ago

3.0.106

1 year ago

3.0.155

12 months ago

3.0.150

12 months ago

3.0.152

12 months ago

3.0.151

12 months ago

3.0.154

12 months ago

3.0.153

12 months ago

3.0.145

12 months ago

3.0.144

12 months ago

3.0.147

12 months ago

3.0.146

12 months ago

3.0.149

12 months ago

3.0.148

12 months ago

3.0.141

12 months ago

3.0.140

12 months ago

3.0.143

12 months ago

3.0.142

12 months ago

3.0.134

1 year ago

3.0.133

1 year ago

3.0.136

1 year ago

3.0.135

1 year ago

3.0.138

1 year ago

3.0.137

1 year ago

3.0.139

12 months ago

3.0.130

1 year ago

3.0.132

1 year ago

3.0.131

1 year 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

4 years ago

1.3.25

4 years ago

1.3.28

3 years ago

1.3.29

3 years ago

1.3.26

4 years ago

1.3.27

3 years ago

1.3.17

4 years ago

1.3.18

4 years ago

1.3.19

4 years ago

1.3.20

4 years ago

1.3.21

4 years ago

1.3.22

4 years ago

1.3.23

4 years ago

1.3.10

4 years ago

1.3.13

4 years ago

1.3.14

4 years ago

1.3.11

4 years ago

1.3.12

4 years ago

1.3.15

4 years ago

1.3.16

4 years ago

1.3.7

4 years ago

1.3.6

4 years ago

1.3.5

4 years ago

1.3.4

4 years ago

1.3.3

4 years ago

1.3.2

4 years ago

1.3.1

4 years ago

1.3.0

4 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

4 years ago

1.3.8

4 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

5 years ago

1.2.15

5 years ago

1.2.14

5 years ago

1.2.13

5 years ago

1.2.12

5 years ago

1.2.11

5 years ago

1.2.10

5 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