Skip to main content
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

  • The Admin role in your Slate workspace. Members can view integrations but can’t connect them.
  • 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 Workspace settings → Integrations.
  2. Under More integrations, find Google Sheets and click Connect.
  3. Optionally, enter a Connection name (e.g., “Marketing Team Google Account”).
  4. Click Continue to Google Sheets. Google’s sign-in page opens in a new window.
  5. Sign in with your Google account and approve access.
  6. The row shows Connected when the connection is ready.
Slate uses Google’s drive.file permission. Slate can only open spreadsheets you pick in Slate and spreadsheets Slate creates. It can’t see your other Drive 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. If it isn’t listed yet, click Connect a Spreadsheet and pick the file in the Google file picker.
  5. Choose a sheet.
  6. Select an action: Read Sheet Values or Append to Sheet Rows.

​
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. 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. 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 Workspace settings → Integrations to see your Google Sheets connections. Each connection shows Connected or Needs attention.

​
Fix a connection that needs attention

Slate refreshes access tokens in the background. A connection shows Needs attention when Google access is revoked or expires. To fix it, connect the account again:
  1. Open the ⋮ menu on the Google Sheets row and choose Add another connection.
  2. Sign in with your Google account and approve access.
  3. In each workflow block that used the old connection, select the new connection.
  4. Remove the old connection.

​
Remove a connection

Open the ⋮ menu on the Google Sheets row and choose Disconnect. If you have more than one connection, expand the row and click Remove next to the connection. Workflows that use the removed connection need a new one.

​
Troubleshooting

​
What’s next