Spreadsheets and databases integrations, ready to switch on
Half the businesses we meet run on a spreadsheet, and they'd like to keep it that way. These pairs write each order, payment, lead or booking as a row in a Google Sheet or an Airtable base you own, and keep the status column current. Your own formulas, filters and extra columns are left alone.
It works in the other direction as well. A row added to a sheet can become a contact, a task or a message, which is the cheapest way to feed an app without learning it.
Sixteen ready-made pairs, $39 to $79 a month. Apps in this category: Airtable, Google Sheets.
Name them 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.
Flat price per integration whatever the volume, cancel any month, and when an app changes its API we fix the integration within a working day. All categories.
What starts each spreadsheets and databases pair
The first row of every pair's table: the event that sets it off, which way the data goes, and how soon. In ten of the sixteen pairs the first move writes into the sheet or base, in six it reads from it. Seven pairs have a move that runs on a schedule rather than on the event; the rest happen within seconds.
| Pair | What starts it | Direction | When | Price |
|---|---|---|---|---|
| Shopify and Google Sheets | New order as a row | Shopify to Google Sheets | Within seconds | $39/mo |
| WooCommerce and Google Sheets | New order as a row | WooCommerce to Google Sheets | Within seconds | $39/mo |
| Google Sheets and Stripe | Payment as a row | Stripe to Google Sheets | Within seconds | $39/mo |
| ActiveCampaign and Google Sheets | New subscriber as a row | ActiveCampaign to Google Sheets | Within seconds | $39/mo |
| Google Sheets and Notion | New row becomes a page | Google Sheets to Notion | Within a minute | $39/mo |
| Kommo and Google Sheets | New lead as a row | Kommo to Google Sheets | Within seconds | $39/mo |
| Airtable and HubSpot | Record becomes a contact | Airtable to HubSpot | Within seconds | $39/mo |
| Jira and Google Sheets | Filter results as rows | Jira to Google Sheets | Within seconds | $39/mo |
| Airtable and Slack | Record enters a view | Airtable to Slack | Within a minute | $39/mo |
| Slack and Google Sheets | New row | Google Sheets to Slack | Within a minute | $39/mo |
| HubSpot and Google Sheets | A tab per pipeline | HubSpot to Google Sheets | Within seconds | $39/mo |
| Airtable and Jira | Record in the view becomes an issue | Airtable to Jira | When it appears in the view you nominate | $39/mo |
| Google Sheets and Mailchimp | Row joins the audience | Google Sheets to Mailchimp | Every few minutes | $39/mo |
| Bitrix24 and Google Sheets | New deal as a row | Bitrix24 to Google Sheets | Within seconds | $39/mo |
| Ozon and Google Sheets | New order as a row | Ozon to Google Sheets | Within seconds | $39/mo |
| 1C and Google Sheets | Documents as rows | 1C to Google Sheets | A few times an hour | $79/mo |
The keys you paste
One per app, created in your own account, checked the moment you paste it. The other app in the pair has its own key on its own page.
- Airtable: Airtable personal access token. Open airtable.com/create/tokens and press create new token. About four min.
- Google Sheets: Google Sheets link. Create or open the spreadsheet, share it with the address our engineer sends you or with anyone who has the link, and paste the link from the address bar. About two min.