4.0.1 • Published 1 month ago

@sprucelabs/jest-sheets-reporter v4.0.1

Weekly downloads
790
License
-
Repository
-
Last release
1 month 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

1 month ago

4.0.0

1 month ago

3.0.219

4 months ago

3.0.218

4 months ago

3.0.222

3 months ago

3.0.221

3 months ago

3.0.224

2 months ago

3.0.223

2 months ago

3.0.226

1 month ago

3.0.225

2 months ago

3.0.220

3 months ago

3.0.208

5 months ago

3.0.207

5 months ago

3.0.209

5 months ago

3.0.211

5 months ago

3.0.210

5 months ago

3.0.213

4 months ago

3.0.212

4 months ago

3.0.215

4 months ago

3.0.214

4 months ago

3.0.217

4 months ago

3.0.216

4 months ago

3.0.200

6 months ago

3.0.202

5 months ago

3.0.201

5 months ago

3.0.204

5 months ago

3.0.203

5 months ago

3.0.206

5 months ago

3.0.205

5 months ago

3.0.190

8 months ago

3.0.199

6 months ago

3.0.192

8 months ago

3.0.191

8 months ago

3.0.194

7 months ago

3.0.193

7 months ago

3.0.196

7 months ago

3.0.195

7 months ago

3.0.198

6 months ago

3.0.197

7 months ago

3.0.189

8 months ago

3.0.188

8 months ago

3.0.183

8 months ago

3.0.185

8 months ago

3.0.184

8 months ago

3.0.187

8 months ago

3.0.186

8 months ago

3.0.181

8 months ago

3.0.182

8 months ago

3.0.180

8 months ago

3.0.178

8 months ago

3.0.177

8 months ago

3.0.179

8 months ago

3.0.172

9 months ago

3.0.174

9 months ago

3.0.173

9 months ago

3.0.176

8 months ago

3.0.175

8 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

9 months ago

3.0.160

9 months ago

3.0.162

9 months ago

3.0.156

9 months ago

3.0.158

9 months ago

3.0.157

9 months ago

3.0.159

9 months ago

3.0.89

10 months ago

3.0.87

11 months ago

3.0.88

10 months ago

3.0.81

12 months ago

3.0.82

12 months ago

3.0.80

12 months ago

3.0.85

12 months ago

3.0.86

12 months ago

3.0.83

12 months ago

3.0.84

12 months ago

3.0.98

10 months ago

3.0.99

10 months ago

3.0.92

10 months ago

3.0.93

10 months ago

3.0.90

10 months ago

3.0.91

10 months ago

3.0.96

10 months ago

3.0.97

10 months ago

3.0.94

10 months ago

3.0.95

10 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

12 months 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

10 months ago

3.0.123

10 months ago

3.0.122

10 months ago

3.0.125

10 months ago

3.0.124

10 months ago

3.0.127

10 months ago

3.0.126

10 months ago

3.0.129

10 months ago

3.0.128

10 months ago

3.0.121

10 months ago

3.0.120

10 months ago

3.0.109

10 months ago

3.0.108

10 months ago

3.0.112

10 months ago

3.0.111

10 months ago

3.0.114

10 months ago

3.0.113

10 months ago

3.0.116

10 months ago

3.0.115

10 months ago

3.0.118

10 months ago

3.0.117

10 months ago

3.0.110

10 months ago

3.0.101

10 months ago

3.0.100

10 months ago

3.0.103

10 months ago

3.0.102

10 months ago

3.0.105

10 months ago

3.0.104

10 months ago

3.0.107

10 months ago

3.0.106

10 months ago

3.0.155

10 months ago

3.0.150

10 months ago

3.0.152

10 months ago

3.0.151

10 months ago

3.0.154

10 months ago

3.0.153

10 months ago

3.0.145

10 months ago

3.0.144

10 months ago

3.0.147

10 months ago

3.0.146

10 months ago

3.0.149

10 months ago

3.0.148

10 months ago

3.0.141

10 months ago

3.0.140

10 months ago

3.0.143

10 months ago

3.0.142

10 months ago

3.0.134

10 months ago

3.0.133

10 months ago

3.0.136

10 months ago

3.0.135

10 months ago

3.0.138

10 months ago

3.0.137

10 months ago

3.0.139

10 months ago

3.0.130

10 months ago

3.0.132

10 months ago

3.0.131

10 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

3 years ago

1.2.302

3 years ago

1.2.305

3 years ago

1.2.304

3 years ago

1.3.9

3 years ago

1.3.8

3 years ago

1.2.310

3 years ago

1.2.312

3 years ago

1.2.311

3 years ago

1.2.314

3 years ago

1.2.313

3 years ago

1.2.316

3 years ago

1.2.315

3 years ago

1.2.307

3 years ago

1.2.306

3 years ago

1.2.309

3 years ago

1.2.308

3 years ago

1.2.318

3 years ago

1.2.317

3 years ago

1.2.319

3 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

4 years ago

1.2.8

4 years ago

1.2.7

4 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