Add your signup sheet to Google Contacts
Adds everyone in your signup spreadsheet to Google Contacts, matching on email so nobody is entered twice.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
The integration steps this workflow runs, in the order it first runs them.
- 1Google SheetsRead rows
- 2Google ContactsList contacts
- 3Google ContactsCreate contact
- 4Google ContactsUpdate contact
How it works
Everything the template sets up, and what to fill in before the first run.
Point this at the spreadsheet your signups or enquiries land in and it keeps Google Contacts in step with it, once a day. Every row is matched against your address book by email address: somebody new is added as a contact, and somebody already there is left in place rather than entered a second time.
Your tab needs a header row with these exact column names: 'First Name', 'Last Name', 'Email' and 'Phone'. The names are fixed - rename the columns in your sheet to match rather than the other way round. 'Last Name' and 'Phone' may be empty.
Nothing already on a contact is ever overwritten. When someone is matched, the workflow only fills in what is blank - a missing phone number, or a missing name - and if your sheet has a different phone number from the one on the card it says so in the summary and changes nothing. A row with no first name, or with nothing usable in the 'Email' column, is skipped and named at the end: without an email there is no safe way to tell that person apart from someone already in your contacts, and guessing risks merging two different people. No contact is ever deleted.
Two things worth knowing. Company names are not stored, because a Google contact here holds a name, an email address and a phone number and nothing else. And matching looks at the first 1000 contacts in your address book, so a larger one may produce the occasional duplicate rather than a match.
Re-running is safe: a second run over an unchanged sheet writes nothing at all. Fill in the 'signupSheetUrl' and 'signupTabName' steps to set it up.
You May Also Be Interested In
Save matching emails to a spreadsheetSaves each new Gmail message that matches your search as a row in your spreadsheet, and never saves the same message twice.
Log Telegram messages to a spreadsheetWrites every message your Telegram bot receives to a Google Sheet as a row - the time, who sent it and exactly what they typed.
Turn feed items into Trello cardsReads the feed you follow every six hours and files each new item as a Trello card, never carding the same item twice.Smart email draft generatorWhen a new email arrives, Claude writes the reply you would have written and leaves it in your Gmail drafts for you to send.
Start from a workflow that already works.
Add "Add your signup sheet to Google Contacts" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required