TormanoKeep a Google Sheet and Tormano in sync in both directions. Rows you add or edit in the sheet become contacts, and new or updated contacts show up in the sheet. It works with a short script you paste once, it is free, and it needs no Google review.
What syncs
Tormano works in a tab called Tormano Contacts (created automatically) with these columns: First Name, Last Name, Email, Phone, Company, Lifecycle Stage, Tormano Contact ID, and Last Synced. Rows are matched to contacts by email. A hidden column keeps both sides in step so changes never loop back and forth.
Step 1 - paste the script (Sheet to CRM)
- In Tormano, go to Settings > Integrations > Google Sheets and click Set up Google Sheets sync, then copy the script.
- Open your Google Sheet and choose Extensions > Apps Script. Delete anything there, paste the script, and click Save.
- In the function dropdown choose tormanoSetup, click Run, and approve the Google prompt.
That is enough for the Sheet to CRM direction: add a row in the Tormano Contacts tab with an email and it becomes a contact within a few minutes. The script also adds a Tormano menu with a Sync now button.
Step 2 - deploy as a Web app (CRM to Sheet)
To also have Tormano write contacts into the sheet:
- In Apps Script, click Deploy > New deployment and choose the type Web app.
- Set Execute as: Me and Who has access: Anyone, then click Deploy.
- Copy the Web app URL and paste it into Tormano on the Google Sheets page.
Then turn on Automatically push new and updated contacts into the sheet, or click Sync all contacts to the sheet now to fill it in one step.
Field mapping and company
Email, first and last name, phone, and lifecycle stage map directly between the columns and the contact. The Company column links to (or creates) a company record in Tormano.
Removing the integration
Click Disconnect on the Google Sheets page. To fully stop the sheet side, delete the script's time trigger and the Web app deployment in Apps Script.