Connect Google Sheets, Google Forms and webhooks
| Integration | What it does | Where to set it up |
|---|---|---|
| Google Sheets sync | Two-way sync between a Google Sheet and your Leads or Contacts | Leads → ⋯ More → Google Sheet sync, or Contacts → ⋯ More → Sync with a Google Sheet |
| Google Forms | Every new Google Form response becomes a lead | Automate → Forms → Edit → Connect Google Form |
| Webhook trigger | Another system (your website, Shopify, Zapier and so on) enrolls a contact into an automation | Inside a saved automation, section Webhook trigger |
| Webhook / API call block | A chat flow notifies another system at any step | Flow Studio → Actions group |
| Store & delivery connectors | Shopify, WooCommerce, Shiprocket and Razorpay | Commerce → Integrations |
| API access | Build your own integration with an API key | Settings → Developer. See Use the Tanvik API |
Connect one Google Sheet to your Leads and, separately, one to your Contacts. Once connected:
- All your existing records are copied into the sheet straight away.
- Changes you make in Tanvik are pushed to the sheet.
- Edits and new rows in the sheet flow back into Tanvik.
- New leads added from the sheet start any Lead Created automations, and new contacts start any Contact Created automations — just like records created any other way.
Open the same menu item again at any time to check the connection. You'll see a Connected badge, an Open sheet ↗ link, how many rows are synced, the time of the Last push and Last pull, and the last error if there was one. To stop syncing, click Disconnect — rows already in the sheet are left as they are.
| Leads sheet column | Notes |
|---|---|
| Name, Phone, Email, Company | Editable in the sheet. A record can't lose its phone number from the sheet |
| Status, Source, Stage, Deal Value, Notes | Editable in the sheet. Deal Value must be a number |
| Tags | Comma separated, e.g. website, hot |
| Intent, Added | Read-only. Set by Tanvik — edits in the sheet are ignored. Added is shown in IST |
| Your custom fields | One column per custom field, after the standard ones |
| Contacts sheet column | Notes |
|---|---|
| Name, Phone, Email, Group, Notes | Editable in the sheet. A record can't lose its phone number from the sheet |
| Tags | Comma separated |
| DND | TRUE or FALSE |
| Your custom fields | One column per custom field |
A connected Google Form feeds a Tanvik form. Each new response is handled exactly like a submission to that Tanvik form: the same default tags, lead assignment and automation apply, and repeat numbers update the existing lead. So set those up in the Tanvik form first. See Capture leads with Forms.
| Good to know | |
|---|---|
| Older responses | Only responses submitted after you connect are imported. A response edited after it was imported is not imported again |
| Missing name | If Name isn't matched or is left blank, the lead is named after its phone number |
| Skipped responses | A response with no phone number or an invalid one can't become a lead. The form editor shows how many were skipped and the latest reason |
| Checking status | The editor shows when Tanvik Last checked the form and the Last error, if any |
| Disconnecting | Click Manage → Disconnect. New responses stop syncing; leads already created stay |
Incoming: start an automation from another system. Any tool that can send a web request — your website, a booking system, Shopify, Zapier — can enroll a contact into an automation. The Webhook trigger needs the Automations feature (Pro plan).
Outgoing: notify another system from a chat flow. In Flow Studio, add a Webhook / API call block at any point in a flow. Enter the Webhook URL and choose POST or GET. It's a simple way to alert your own system when, for example, a customer finishes a booking conversation.
If your plan includes Commerce, go to Commerce → Integrations. Connected tools are listed first, with Settings and Sync now; the ones you can add sit under Available (or Add more) with a Connect button:
| Connector | What it does |
|---|---|
| Shopify | Syncs products and orders from your Shopify store. See Connect Shopify |
| WooCommerce | Syncs products and orders from your WooCommerce store |
| Shiprocket | Pushes orders to Shiprocket for fulfilment and brings back the AWB number and tracking |
| Razorpay | Collect UPI, card and netbanking payments and send payment links on WhatsApp. Set up opens the Payment Gateway page |
Delhivery, PetPooja POS and Shadowfax are listed as Coming soon. For the full commerce setup, see Sell on WhatsApp with Commerce.
| Problem | Fix |
|---|---|
| Sheet sync says "Connect failed" | Check you shared the sheet with the Tanvik address as Editor (not Viewer or Commenter), and that you pasted the right sheet link |
| "A sync for this sheet is running right now" | Tanvik is already syncing that sheet. Wait a minute and try again |
| A new sheet row didn't appear in Tanvik | Make sure the row has a Phone. Rows without one are skipped |
| Sheet sync shows a "Last error" | Usually the sheet was unshared or deleted. Fix access, or Disconnect and connect again. Tanvik also alerts you in the notifications bell when syncing starts failing |
| Google Form won't connect | Use the form's edit link (ending in /edit) and share the form with the Tanvik address as Editor |
| "Match one question to Phone first" | Pick Phone for the question that asks for a phone or WhatsApp number |
| Google Form responses stopped arriving | Check the Tanvik form isn't paused, and look for a Last error in the Google Form section of the form editor |
| Webhook calls don't enroll anyone | Check the key's switch is on, the key is copied exactly, and a valid phone number is sent in contact_phone |
Was this article helpful?