3.0.26 • Published 10 months ago

@sprucelabs/jest-sheets-reporter v3.0.26

Weekly downloads
790
License
-
Repository
-
Last release
10 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. On the service account details page, click "KEYS" tab
  9. Click Add Key -> JSON
  10. Take the download private key and open it
  11. client_email -> GOOGLE_SERVICE_EMAIL
  12. private_key -> GOOGLE_SERVICE_PRIVATE_KEY
  13. 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
3.0.26

10 months ago

3.0.13

1 year ago

3.0.16

12 months ago

3.0.17

12 months ago

3.0.14

1 year ago

3.0.15

1 year ago

3.0.23

12 months ago

3.0.24

12 months ago

3.0.21

12 months ago

3.0.22

12 months ago

3.0.25

11 months ago

3.0.20

12 months ago

3.0.18

12 months ago

3.0.19

12 months ago

3.0.4

1 year ago

3.0.3

1 year ago

3.0.2

1 year ago

3.0.1

1 year ago

3.0.8

1 year ago

3.0.7

1 year ago

3.0.6

1 year ago

3.0.5

1 year ago

3.0.0

1 year ago

3.0.9

1 year ago

3.0.12

1 year ago

3.0.10

1 year ago

3.0.11

1 year ago

2.0.15

2 years ago

2.0.16

2 years ago

2.0.13

2 years ago

2.0.14

2 years ago

2.0.11

2 years ago

2.0.12

2 years ago

2.0.10

2 years ago

2.0.19

2 years ago

2.0.17

2 years ago

2.0.18

2 years ago

2.0.20

2 years ago

2.0.21

2 years ago

2.0.3

2 years ago

2.0.2

2 years ago

2.0.5

2 years ago

2.0.4

2 years ago

2.0.7

2 years ago

2.0.6

2 years ago

2.0.9

2 years ago

2.0.8

2 years ago

2.0.1

2 years ago

2.0.0

2 years ago

1.3.117

2 years ago

1.3.116

2 years ago

1.3.119

2 years ago

1.3.118

2 years ago

1.3.124

2 years ago

1.3.123

2 years ago

1.3.122

2 years ago

1.3.121

2 years ago

1.3.120

2 years ago

1.3.102

2 years ago

1.3.101

2 years ago

1.3.100

2 years ago

1.3.106

2 years ago

1.3.105

2 years ago

1.3.104

2 years ago

1.3.103

2 years ago

1.3.109

2 years ago

1.3.108

2 years ago

1.3.107

2 years ago

1.3.113

2 years ago

1.3.112

2 years ago

1.3.111

2 years ago

1.3.110

2 years ago

1.3.115

2 years ago

1.3.114

2 years ago

1.3.90

2 years ago

1.3.93

2 years ago

1.3.94

2 years ago

1.3.91

2 years ago

1.3.92

2 years ago

1.3.97

2 years ago

1.3.98

2 years ago

1.3.95

2 years ago

1.3.96

2 years ago

1.3.99

2 years ago

1.3.87

2 years ago

1.3.88

2 years ago

1.3.89

2 years ago

1.3.82

2 years ago

1.3.83

2 years ago

1.3.86

2 years ago

1.3.84

2 years ago

1.3.85

2 years ago

1.3.50

2 years ago

1.3.53

2 years ago

1.3.54

2 years ago

1.3.51

2 years ago

1.3.52

2 years ago

1.3.57

2 years ago

1.3.58

2 years ago

1.3.55

2 years ago

1.3.56

2 years ago

1.3.59

2 years ago

1.3.60

2 years ago

1.3.61

2 years ago

1.3.64

2 years ago

1.3.65

2 years ago

1.3.62

2 years ago

1.3.63

2 years ago

1.3.68

2 years ago

1.3.69

2 years ago

1.3.66

2 years ago

1.3.67

2 years ago

1.3.47

2 years ago

1.3.48

2 years ago

1.3.49

2 years ago

1.3.71

2 years ago

1.3.72

2 years ago

1.3.70

2 years ago

1.3.75

2 years ago

1.3.76

2 years ago

1.3.73

2 years ago

1.3.74

2 years ago

1.3.79

2 years ago

1.3.77

2 years ago

1.3.78

2 years ago

1.3.80

2 years ago

1.3.81

2 years ago

1.3.46

2 years ago

1.3.44

2 years ago

1.3.45

2 years ago

1.3.39

2 years ago

1.3.42

2 years ago

1.3.43

2 years ago

1.3.40

2 years ago

1.3.41

2 years ago

1.3.38

2 years ago

1.3.36

2 years ago

1.3.37

2 years ago

1.3.31

2 years ago

1.3.32

2 years ago

1.3.30

2 years ago

1.3.35

2 years ago

1.3.33

2 years ago

1.3.34

2 years ago

1.3.24

2 years ago

1.3.25

2 years ago

1.3.28

2 years ago

1.3.29

2 years ago

1.3.26

2 years ago

1.3.27

2 years ago

1.3.17

2 years ago

1.3.18

2 years ago

1.3.19

2 years ago

1.3.20

2 years ago

1.3.21

2 years ago

1.3.22

2 years ago

1.3.23

2 years ago

1.3.10

2 years ago

1.3.13

2 years ago

1.3.14

2 years ago

1.3.11

2 years ago

1.3.12

2 years ago

1.3.15

2 years ago

1.3.16

2 years ago

1.3.7

2 years ago

1.3.6

2 years ago

1.3.5

2 years ago

1.3.4

2 years ago

1.3.3

2 years ago

1.3.2

2 years ago

1.3.1

2 years ago

1.3.0

2 years ago

1.2.301

2 years ago

1.2.300

2 years ago

1.2.303

2 years ago

1.2.302

2 years ago

1.2.305

2 years ago

1.2.304

2 years ago

1.3.9

2 years ago

1.3.8

2 years ago

1.2.310

2 years ago

1.2.312

2 years ago

1.2.311

2 years ago

1.2.314

2 years ago

1.2.313

2 years ago

1.2.316

2 years ago

1.2.315

2 years ago

1.2.307

2 years ago

1.2.306

2 years ago

1.2.309

2 years ago

1.2.308

2 years ago

1.2.318

2 years ago

1.2.317

2 years ago

1.2.319

2 years ago

1.2.299

2 years ago

1.2.298

2 years ago

1.2.293

2 years ago

1.2.295

2 years ago

1.2.294

2 years ago

1.2.297

2 years ago

1.2.296

2 years ago

1.2.255

2 years ago

1.2.254

2 years ago

1.2.257

2 years ago

1.2.256

2 years ago

1.2.259

2 years ago

1.2.258

2 years ago

1.2.251

2 years ago

1.2.250

2 years ago

1.2.253

2 years ago

1.2.252

2 years ago

1.2.266

2 years ago

1.2.265

2 years ago

1.2.268

2 years ago

1.2.267

2 years ago

1.2.269

2 years ago

1.2.260

2 years ago

1.2.262

2 years ago

1.2.261

2 years ago

1.2.264

2 years ago

1.2.263

2 years ago

1.2.277

2 years ago

1.2.276

2 years ago

1.2.279

2 years ago

1.2.278

2 years ago

1.2.271

2 years ago

1.2.270

2 years ago

1.2.273

2 years ago

1.2.272

2 years ago

1.2.275

2 years ago

1.2.274

2 years ago

1.2.288

2 years ago

1.2.287

2 years ago

1.2.289

2 years ago

1.2.280

2 years ago

1.2.282

2 years ago

1.2.281

2 years ago

1.2.284

2 years ago

1.2.283

2 years ago

1.2.286

2 years ago

1.2.285

2 years ago

1.2.237

3 years ago

1.2.239

2 years ago

1.2.238

2 years ago

1.2.244

2 years ago

1.2.243

2 years ago

1.2.246

2 years ago

1.2.245

2 years ago

1.2.248

2 years ago

1.2.247

2 years ago

1.2.249

2 years ago

1.2.240

2 years ago

1.2.242

2 years ago

1.2.241

2 years ago

1.2.291

2 years ago

1.2.290

2 years ago

1.2.292

2 years ago

1.2.235

3 years ago

1.2.236

3 years ago

1.2.233

3 years ago

1.2.234

3 years ago

1.2.232

3 years ago

1.2.231

3 years ago

1.2.211

3 years ago

1.2.210

3 years ago

1.2.213

3 years ago

1.2.212

3 years ago

1.2.215

3 years ago

1.2.214

3 years ago

1.2.217

3 years ago

1.2.216

3 years ago

1.2.208

3 years ago

1.2.207

3 years ago

1.2.209

3 years ago

1.2.222

3 years ago

1.2.221

3 years ago

1.2.224

3 years ago

1.2.223

3 years ago

1.2.226

3 years ago

1.2.225

3 years ago

1.2.228

3 years ago

1.2.227

3 years ago

1.2.220

3 years ago

1.2.219

3 years ago

1.2.218

3 years ago

1.2.230

3 years ago

1.2.229

3 years ago

1.2.202

3 years ago

1.2.204

3 years ago

1.2.203

3 years ago

1.2.206

3 years ago

1.2.205

3 years ago

1.2.200

3 years ago

1.2.201

3 years ago

1.2.189

3 years ago

1.2.188

3 years ago

1.2.185

3 years ago

1.2.187

3 years ago

1.2.186

3 years ago

1.2.199

3 years ago

1.2.192

3 years ago

1.2.191

3 years ago

1.2.194

3 years ago

1.2.193

3 years ago

1.2.196

3 years ago

1.2.195

3 years ago

1.2.198

3 years ago

1.2.197

3 years ago

1.2.190

3 years ago

1.2.169

3 years ago

1.2.178

3 years ago

1.2.177

3 years ago

1.2.179

3 years ago

1.2.170

3 years ago

1.2.172

3 years ago

1.2.171

3 years ago

1.2.174

3 years ago

1.2.173

3 years ago

1.2.176

3 years ago

1.2.175

3 years ago

1.2.181

3 years ago

1.2.180

3 years ago

1.2.183

3 years ago

1.2.182

3 years ago

1.2.184

3 years ago

1.2.134

3 years ago

1.2.133

3 years ago

1.2.136

3 years ago

1.2.135

3 years ago

1.2.138

3 years ago

1.2.137

3 years ago

1.2.139

3 years ago

1.2.130

3 years ago

1.2.132

3 years ago

1.2.131

3 years ago

1.2.145

3 years ago

1.2.144

3 years ago

1.2.147

3 years ago

1.2.146

3 years ago

1.2.149

3 years ago

1.2.148

3 years ago

1.2.141

3 years ago

1.2.140

3 years ago

1.2.143

3 years ago

1.2.142

3 years ago

1.2.156

3 years ago

1.2.155

3 years ago

1.2.158

3 years ago

1.2.157

3 years ago

1.2.159

3 years ago

1.2.150

3 years ago

1.2.152

3 years ago

1.2.151

3 years ago

1.2.154

3 years ago

1.2.153

3 years ago

1.2.167

3 years ago

1.2.166

3 years ago

1.2.168

3 years ago

1.2.161

3 years ago

1.2.160

3 years ago

1.2.163

3 years ago

1.2.162

3 years ago

1.2.165

3 years ago

1.2.164

3 years ago

1.2.112

3 years ago

1.2.111

3 years ago

1.2.114

3 years ago

1.2.113

3 years ago

1.2.116

3 years ago

1.2.115

3 years ago

1.2.118

3 years ago

1.2.117

3 years ago

1.2.123

3 years ago

1.2.122

3 years ago

1.2.125

3 years ago

1.2.124

3 years ago

1.2.127

3 years ago

1.2.126

3 years ago

1.2.129

3 years ago

1.2.128

3 years ago

1.2.121

3 years ago

1.2.120

3 years ago

1.2.119

3 years ago

1.2.97

3 years ago

1.2.98

3 years ago

1.2.99

3 years ago

1.2.101

3 years ago

1.2.100

3 years ago

1.2.103

3 years ago

1.2.102

3 years ago

1.2.105

3 years ago

1.2.104

3 years ago

1.2.107

3 years ago

1.2.106

3 years ago

1.2.110

3 years ago

1.2.109

3 years ago

1.2.108

3 years ago

1.2.92

3 years ago

1.2.93

3 years ago

1.2.96

3 years ago

1.2.94

3 years ago

1.2.95

3 years ago

1.2.89

3 years ago

1.2.90

3 years ago

1.2.91

3 years ago

1.2.86

3 years ago

1.2.87

3 years ago

1.2.88

3 years ago

1.2.82

3 years ago

1.2.85

3 years ago

1.2.83

3 years ago

1.2.84

3 years ago

1.2.81

3 years ago

1.2.80

3 years ago

1.2.78

3 years ago

1.2.79

3 years ago

1.2.77

3 years ago

1.2.76

3 years ago

1.2.75

3 years ago

1.2.70

3 years ago

1.2.71

3 years ago

1.2.74

3 years ago

1.2.72

3 years ago

1.2.73

3 years ago

1.2.67

3 years ago

1.2.68

3 years ago

1.2.66

3 years ago

1.2.69

3 years ago

1.2.65

3 years ago

1.2.63

3 years ago

1.2.64

3 years ago

1.2.60

3 years ago

1.2.61

3 years ago

1.2.62

3 years ago

1.2.58

3 years ago

1.2.59

3 years ago

1.2.57

3 years ago

1.2.56

3 years ago

1.2.54

3 years ago

1.2.55

3 years ago

1.2.53

3 years ago

1.2.52

3 years ago

1.2.50

3 years ago

1.2.51

3 years ago

1.2.49

3 years ago

1.2.47

3 years ago

1.2.48

3 years ago

1.2.46

3 years ago

1.2.45

3 years ago

1.2.44

3 years ago

1.2.43

3 years ago

1.2.42

3 years ago

1.2.41

3 years ago

1.2.40

3 years ago

1.2.39

3 years ago

1.2.38

3 years ago

1.2.37

3 years ago

1.2.23

3 years ago

1.2.22

3 years ago

1.2.21

3 years ago

1.2.20

3 years ago

1.2.19

3 years ago

1.2.18

3 years ago

1.2.17

3 years ago

1.2.16

3 years ago

1.2.15

3 years ago

1.2.14

3 years ago

1.2.13

3 years ago

1.2.12

3 years ago

1.2.11

3 years ago

1.2.10

3 years ago

1.2.9

3 years ago

1.2.8

3 years ago

1.2.7

3 years ago

1.2.6

3 years ago

1.2.5

4 years ago

1.2.4

4 years ago

1.2.3

4 years ago

1.2.2

4 years ago

1.2.1

4 years ago

1.2.0

4 years ago

1.1.2

4 years ago

1.1.1

4 years ago

1.1.0

4 years ago

1.0.0

4 years ago