Find and update Apollo contacts from new or updated Google Sheets rows
For people who are shared between Apollo and a Google Spreadsheet, this template can be used to ensure that they are always kept up-to-date in Apollo whenever a new update is made to the spreadsheet.
For people who are shared between Apollo and a Google Spreadsheet, this template can be used to ensure that they are always kept up-to-date in Apollo whenever a new update is made to the spreadsheet.
- When this happens...New or Updated Spreadsheet Row
Triggers when a new row is added or modified in a spreadsheet.
- automatically do this...Find Contact
Find a contact in your Apollo instance by searching for their email. If you have multiple contacts with the same email address, this search returns the contact that was created first.
- then do this!Update Contact
Update an already existing Contact.
- Free forever for core features
- 14 day trial for premium features & apps
Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItDrive
Try ItDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItDrive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
Dont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItDrive
SpreadsheetRequired
Try ItDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?