TormanoKeep a Google Sheet and Tormano in step in both directions. Rows you add or edit in the sheet become contacts, and new or updated contacts appear in the sheet. It takes one short script, pasted once, and it is free.
What syncs
Tormano works in a tab called Tormano Contacts, created for you, with columns for first name, last name, email, phone, company, lifecycle stage, a Tormano reference, and when the row was last synced. Rows are matched to contacts by email, and a change made on one side never bounces back to the other.
Step 1: sheet to Tormano
- 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 rows to reach Tormano: add one to the Tormano Contacts tab with an email address and it becomes a contact within a few minutes. The script also adds a Tormano menu with a Sync now button.
Step 2: Tormano to sheet
To have Tormano write contacts into the sheet as well:
- 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 move straight between the columns and the contact. The Company column links the contact to a company in Tormano, creating one if it doesn’t exist yet.
Removing the integration
Click Disconnect on the Google Sheets page. To stop the sheet side as well, open Triggers in Apps Script, delete the Tormano trigger, and remove the Web app deployment.