Type alias GoogleSheetsTableOptions

Type declaration

• columnConstraints: ColumnConstraints

  Column constraints used when inserting or updating data in the table.

• credentials: JWTInput

  The credentials used to call the Google Sheets API.

  Example

  // using a Google service account
  {
    client_email: "service-account@your-project-123456.iam.gserviceaccount.com",
    private_key: "your-service-account-private-key"
  }
  Copy

• sheetName: string

  The name of the sheet within the Google Sheets spreadsheet that contains the table

• spreadsheetId: string

  The [spreadsheet ID]https://developers.google.com/sheets/api/guides/concepts or Google Drive file ID of the Google Spreadsheet containing the table.