Google Sheets

Connect your Google account to Slate and read or write spreadsheet data directly from your workflows.

The Google Sheets integration lets you read data from and write data to Google Sheets within your Slate workflows. Pull spreadsheet rows as workflow inputs, or append AI-generated results back to a sheet.

Why connect Google Sheets to Slate?

Many teams manage content briefs, keyword lists, and campaign data in Google Sheets. Connecting Google Sheets to Slate lets you use that data as input for AI workflows and write results back — no manual copy-pasting.

Prerequisites

• A Slate account with an active workspace
• A Google account with access to the spreadsheets you want to use

Setup

Step 1: Connect Google Sheets in Slate

1. Open Slate and go to Administration > Integrations.
2. Find Google Sheets and click Connect.
3. Enter a name for the connection (e.g., “Marketing Team Google Account”).
4. Click Connect. Slate redirects you to Google’s sign-in page.
5. Sign in with your Google account and grant Slate access to your spreadsheet files.
6. After authorization, Google redirects you back to Slate. The connection appears as active.

Slate requests access to spreadsheet files in your Google Drive only. It does not access other files, emails, or personal data.

Step 2: Use the connection in a workflow

1. Open or create a workflow.
2. Add the Google Sheets block from the Apps section.
3. Select your Google Sheets connection from the dropdown.
4. Choose a spreadsheet and sheet.
5. Select an action: Read or Append.

What you can do

The Google Sheets integration supports two actions through the workflow block:

Read sheet values

Pull data from a Google Sheet into your workflow.

Setting	Description
Spreadsheet	The Google Sheets file to read from
Sheet	The specific sheet tab within the spreadsheet
Header present	Whether the first row contains column headers
Columns	Which columns to include in the result
Row ranges	Start and end rows to read (e.g., rows 2 through 100)

The block returns the selected data as structured output that subsequent workflow steps can reference.

Append to sheet

Write new rows to a Google Sheet.

Setting	Description
Spreadsheet	The Google Sheets file to write to
Sheet	The specific sheet tab within the spreadsheet
Header present	Whether the first row contains column headers
Column mappings	Map workflow data to spreadsheet columns
Data	JSON input — supports placeholders from previous steps

New rows are inserted at the end of the sheet. Existing data is not modified.

Use cases

Content brief processing

Store content briefs in a Google Sheet with columns like topic, target keyword, and audience. Read the sheet in a workflow, generate articles for each row with the LLM block, and append results (title, body, meta description) back to the sheet.

Example flow: Google Sheets block reads briefs → Loop block iterates rows → LLM generates article per row → Google Sheets block appends results

Keyword research pipeline

Start with a list of seed keywords in a Google Sheet. Run them through Semrush blocks for search volume and difficulty data, then write the enriched data back to the sheet.

Example flow: Google Sheets block reads keyword list → Semrush Keyword Overview block enriches each keyword → Google Sheets block appends metrics

Bulk publishing from a sheet

Combine Google Sheets with the Webflow or WordPress integration. Read content from a sheet and publish each row as a new page or post.

Example flow: Google Sheets block reads content rows → Loop block iterates → WordPress block creates a post per row

AI search analytics export

Run AI analytics queries through a workflow and log the results to a Google Sheet for reporting or sharing with stakeholders.

Example flow: Call API block fetches analytics data → Code block formats results → Google Sheets block appends to a reporting sheet

Campaign tracking and updates

Maintain a campaign tracker in Google Sheets. Read the sheet to generate status reports or content updates, then write summaries back.

Example flow: Google Sheets block reads campaign data → LLM generates status summary → Google Sheets block appends summary column

Managing connections

View connections

Go to Administration > Integrations to see all your Google Sheets connections and their status.

Re-authenticate

If your Google authorization expires or is revoked:

1. Open the connection in Slate under Administration > Integrations.
2. Click Reconnect.
3. Sign in with your Google account again and grant access.

Slate automatically refreshes access tokens in the background. Manual re-authentication is only needed if you revoke access from your Google account settings.

Remove a connection

Delete a connection from Administration > Integrations. Any workflows using that connection will need to be updated with a new one.

Troubleshooting

Issue	Cause	Solution
Connection fails during OAuth	Pop-ups blocked or network issue	Allow pop-ups for Slate and try again
Spreadsheet not listed	File not in the connected Google account	Verify the spreadsheet is owned by or shared with the connected account
”Permission denied” errors	Google access revoked	Re-authenticate the connection in Slate
Empty data returned	Wrong sheet tab or row range selected	Check the sheet name and row range match where your data is
Append writes to wrong columns	Column mapping mismatch	Verify column numbers in the mapping match the spreadsheet layout
Headers not detected	”Header present” toggle is off	Enable the header toggle if your first row contains column names

What’s next

• Google Sheets Workflow Block — detailed guide on configuring the Google Sheets block in workflows
• Building Workflows — learn how to create workflows from scratch
• Loop Block — process multiple rows in a single workflow
• Webflow Integration — publish sheet data to Webflow CMS
• WordPress Integration — publish sheet data to WordPress