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
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
- 1Google SheetsRead rowsReads every row of your signup tab, taking the first name, last name, email and phone from each.
- 2Google ContactsList contactsReads your address book so each signup can be matched by email address to a contact already there.
For each
signupRowIf
matchIndexis less than 0- 3Google ContactsCreate contactCreates a contact with the name, email and phone from the row when no existing contact has that email.
Otherwise, if
existingResourceis not empty and (firstNameToAddis not empty orphoneToAddis not empty)- 4Google ContactsUpdate contactFills in a missing name or phone number on a matched contact, never overwriting anything already on the card.
- 3
How it works
What happens on each run, in plain English.
Once a day, the spreadsheet your signups or enquiries land in is checked against Google Contacts. Every row is matched to your address book by email address: somebody new is added as a contact, and somebody already there is left in place rather than entered twice.
Nothing already on a contact is ever overwritten. When a row matches an existing contact, only what is blank is added, such as a missing phone number or name, and if your sheet holds a different phone number from the card it says so in the run summary and changes nothing. A row with no first name, or nothing usable in the 'Email' column, is skipped and named at the end, because without an email there is no safe way to tell that person from someone already there. No contact is ever deleted, and an unchanged sheet writes nothing.
Your tab needs a header row with the columns 'First Name', 'Last Name', 'Email' and 'Phone'; last name and phone may be empty. Company names are not stored.
You may also be interested in
Find matching rows in a spreadsheetEvery hour, finds the rows on a Google Sheets tab where a column holds a value you choose, or is empty, ready for the steps you add.
Fill a spreadsheet with a ChatGPT-written list every hourEvery hour, has ChatGPT write a fresh batch of the list you describe and adds each item as a row in your Google Sheet.
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.
Daily news digest from your sheetEvery morning, has Claude pick the ten best stories logged in your news sheet, emails them to you with links, and clears the sheet.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.
Free plan, no credit card