Google Sheets app
Create, find, and update Google Sheets rows in workflows.
Available on all plans.
Admins can install the Google Sheets app. Each member connects their own Google account.
The Google Sheets app connects your Attio workflows to Google Sheets. Use it to add rows, look up existing rows, and update values in a spreadsheet as part of a workflow. The app works with spreadsheets you've already created.
Install the Google Sheets app
A workspace admin installs the app for the workspace:
Click your workspace name, select Workspace settings, then go to Apps in the sidebar.
Search for and open the Google Sheets app, then click Install.
Each member who wants to use Google Sheets in a workflow then connects their own Google account from the same app page. If a member does not yet have a connection, Attio prompts them to add it within the workflow builder. When you connect, Attio asks for permission to view and edit your spreadsheets, and to see the names of the files in your Google Drive so you can choose a spreadsheet.
Each step runs using the Google account you choose when you set it up, so a step can only open spreadsheets that account already has access to.
Use Google Sheets steps in a workflow
Every Google Sheets step asks you to choose a spreadsheet and a tab within it. You can pick columns either by their header name or by their column letter, such as A or B.
Create row
Adds a new row to a tab, with values for one or more columns.
Inputs:
Mode: Select append to add the row at the bottom of the tab, or prepend to add it at the top.
Columns: The columns to write to and the value for each.
Outputs: the row that was written, including its row number and values.
Note: Append is the recommended mode. If several workflow runs prepend rows to the same tab at the same moment, they can overwrite each other. Use prepend only when new rows need to appear at the top and you don't expect many runs at once.
Find matching row
Finds the first row that matches the column values you choose.
Inputs:
Columns: The columns to match on and the value each one should equal.
Outcomes:
Row found: The first matching row, including its row number and values.
No row found: Nothing in the tab matched every column and value.
Find matching rows
Finds every row that matches the column values you choose.
Inputs:
Columns: The columns to match on and the value each one should equal.
Outcomes:
Rows found: All matching rows, including their row numbers and values.
No rows found: Nothing in the tab matched every column and value.
Find or create row
Looks for a matching row, and adds a new one at the bottom of the tab if nothing matches. Attio uses the same values you matched on to fill in the new row.
Inputs:
Columns: The columns to match on and the value each one should equal.
Outcomes:
Existing row found: The matching row, including its row number and values.
Row created: The new row, including its row number and values.
Update row
Finds the first row that matches, then updates one or more of its columns.
Inputs:
Lookup columns: The columns to match on and the value each one should equal.
Columns: The columns to update on the matching row and their new values.
Outcomes:
Row updated: The updated row, including its row number and values.
Row not found: Nothing in the tab matched every lookup column and value.
Related resources
Learn more about building automations in Create a workflow and the Workflows block library.