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
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:
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:
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. Check out more ways to connect Attio to the apps you love.