Guides
/
Workflows

Send new Google Sheets rows to your Attio collection 

Google Sheets is a popular spreadsheet app included with Google Workspace. Use this Zap to automatically send new entries to your Attio collection when a new row is added in your Google Sheet.

Prep: Connect Google Sheets to Zapier

You’ll first need to connect your Google Sheets account to Zapier - follow this short guide to get started.

Prep: Connect Attio to Zapier

Follow our short guide on connecting Attio and Zapier, making sure you've set up your API key with read and write permissions.

1. Build your Google Sheets trigger

From your Zapier dashboard, click Create Zap in the top left. Search for Google Sheets from the App Event window, and from the Trigger Event dropdown pick New Spreadsheet Row. Choose your Google Sheets account, Spreadsheet and Worksheet when prompted. Continue to test your trigger.

2. Find or create a person in Attio

Next, we’ll tell Zapier to send new row data to your Attio workspace. Add a new action step with the + icon, and pick Attio from the App Event dropdown. For Action Event choose Find or Create a Person. Select your Attio account. Mapping the fields using the data from step 2, set your action up like this:

An action in Zapier to create a new person record in Attio using name and email address data from Google Sheets
Map fields using data pulled from prior steps in the Zap
If your Google Sheet collects names using one field instead of two, you’ll need an extra step in your Zap. Read more about splitting names in Zapier.

3. Create a new entry in your collection

Next, add another action step to your Zap and pick Attio from the dropdown. Choose Find or Create Entry from the Action Event dropdown, and select your Attio account when prompted.

For Record ID, you’ll need to map data from the Find or Create a Person step in your Zap. Choose Find or Create Person from the Record ID dropdown, followed by Show all options. Scroll down to find ID. Your action should look like this:

A final action step in the Zap that will create a new entry in an Attio collection called Sales
Create a new entry in your Attio collection using values from previous steps

That’s it! Now every time a new row is added to your chosen Google Sheet, Zapier will send a new entry to your Attio collection.

Couldn't find something?

Send us a message in the chat on the right ✌️

© 2022 Attio Ltd. All rights reserved.