Google Sheets integrations, ready to switch on
Google Sheets is the report everyone already knows how to read, and it makes a fine landing place for orders, payments, leads or bookings. One row per record, updated when the record changes. You share a sheet and paste the link; the sheet gets its first rows when the integration is switched on.
Spreadsheets and databases · all Spreadsheets and databases integrations · sheets.google.com
Google Sheets and the apps it talks to
Thirteen pairs, $39 to $79 a month, flat whatever the volume, all on the same Google Sheets link. Click a pair to see exactly what moves, and when.
CRM
Kommo and Google Sheets
Leads, stages and amounts as rows anyone in the office can read
$39/mo
Connect
HubSpot and Google Sheets
A tab per pipeline with a live row per deal, and an import tab that makes contacts
$39/mo
Connect
Bitrix24 and Google Sheets
Deals and leads as rows, rewritten as the stage and the sum change
$39/mo
Connect
Shops and marketplaces
Shopify and Google Sheets
Every order as a row, with variants, fulfilment and refunds tracked
$39/mo
Connect
WooCommerce and Google Sheets
Every order as a row, with coupons, tax and shipping split out
$39/mo
Connect
Ozon and Google Sheets
Marketplace orders as rows with status, tracking and stock counts
$39/mo
Connect
Name the second app and say what should go where. A person replies with a price within a working day, and the finished integration shows up in the same account as the ready-made ones.
What Google Sheets sends and receives
Each line is a row from one pair's table, in that pair's own words. Open the pair for the rule behind it.
Out of Google Sheets
- Rows back into ActiveCampaign to ActiveCampaign, every few minutes
- New row becomes a page to Notion, within a minute
- Edits follow to Notion, within a minute
- Requests tab opens issues to Jira, every few minutes
- New row to Slack, within a minute
- Changed cells to Slack, within a minute
- Owner gets a direct message to Slack, within a minute
- Rows due today to Slack, weekday mornings at 09:00
Into Google Sheets
- New order as a row from Shopify, within seconds
- Payment and fulfilment apart from Shopify, within seconds
- Lines with SKU and variant from Shopify, with every order
- Refunds and returns from Shopify, when they are made
- Duplicate check from Shopify, every order
- Status column follows the order from WooCommerce, within seconds
- Coupons from WooCommerce, with every order
- Lines with SKU from WooCommerce, with every order
Good to know about Google Sheets
- Google Sheets doesn't tell anyone when a cell changes, so anything we read back out of a sheet is picked up on a short schedule rather than the moment you type it.
- Sharing with anyone who has the link is the quick way; sharing only with the address our engineer sends you works the same and keeps the sheet private.
Before you decide
What do I paste to connect Google Sheets?
Google Sheets link. Create a new spreadsheet in Google Sheets, or open the one you want the orders in. About two minutes, and we check the key the moment you paste it.
What if the pair I need isn't here?
Describe it: name the second app and say what should go where. A person replies with a price within a working day, and the finished integration shows up in the same account as the ready-made ones.
What happens when Google Sheets changes its API?
We fix the integration on our side within a working day. You don't get a ticket to solve.