Google Sheets

sheets.google.com

Read from and write to spreadsheets programmatically.

Using the Google Sheets API with Trigger.dev

You can use Trigger.dev with any existing Node SDK or even just using fetch. Using io.runTask makes your Google Sheets background job resumable and appear in our dashboard.

Use io.runTask() and the official SDK or fetch.

Use our HTTP endpoint to subscribe to webhooks

Example code using Google Sheets

Below are some working code examples of how you can use Google Sheets with Trigger.dev. These samples are open source and maintained by the community, you can copy and paste them into your own projects.

Insert data into a row in Google Sheets.A job that is triggered by a Google Sheets webhook.

1
import { config } from "dotenv";
2
import { TriggerClient, eventTrigger } from "@trigger.dev/sdk";
3
import { google } from "googleapis";
4
import { JWT } from "google-auth-library";
5
import z from "zod";
6
// Create a service account and project: https://cloud.google.com/iam/docs/service-account-overview
7
// Create a JWT (JSON Web Token) authentication instance for Google APIs.
8
// https://cloud.google.com/nodejs/docs/reference/google-auth-library/latest/google-auth-library/jwt
9
const auth = new JWT({
10
  email: process.env.GOOGLE_CLIENT_EMAIL, // The email associated with the service account
11
  key: process.env.GOOGLE_PRIVATE_KEY!.split(String.raw`\n`).join("\n"), // The private key associated with the service account
12
  scopes: "https://www.googleapis.com/auth/spreadsheets", // The desired scope for accessing Google Sheets
13
});
14

15
// You have to enable the Google Sheets API: https://console.cloud.google.com/apis/
16
const sheets = google.sheets({ version: "v4", auth });
17

18
client.defineJob({
19
  id: "google-sheets-append",
20
  name: "Google Sheets Append",
21
  version: "1.0.0",
22
  trigger: eventTrigger({
23
    name: "google-sheets",
24
    schema: z.object({
25
      fullName: z.string(),
26
      githubUrl: z.string(),
27
      range: z.string().optional(),
28
    }),
29
  }),
30
  run: async (payload, io, ctx) => {
31
    const { fullName, githubUrl, range } = payload;
32

33
    // Wrap an SDK call in io.runTask so it's resumable and displays in logs
34
    await io.runTask(
35
      "Google Sheets append row",
36
      async () => {
37
        const sheetsData = [[fullName, githubUrl]];
38

39
        const sheetsAPI = sheets.spreadsheets.values;
40

41
        await sheetsAPI.append({
42
          // NB: You must share your Google Sheet with your service account email
43
          spreadsheetId: process.env.SPREADSHEET_ID,
44
          // Set a spreadsheet range
45
          range: range,
46
          valueInputOption: "USER_ENTERED",
47
          insertDataOption: "INSERT_ROWS",
48
          requestBody: {
49
            values: sheetsData,
50
          },
51
        });
52
      },
53

54
      // Add metadata to improve how the task displays in the logs
55
      { name: "Google Sheets append", icon: "google" }
56
    );
57
  },
58
});