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.

Shopify and Google Sheets Every order as a row, with variants, fulfilment and refunds tracked You paste: Shopify Admin API token, Google Sheets link $39/mo Connect WooCommerce and Google Sheets Every order as a row, with coupons, tax and shipping split out You paste: WooCommerce REST API keys, Google Sheets link $39/mo Connect Google Sheets and Stripe Payments, refunds and payouts as rows that reconcile with your bank You paste: Google Sheets link, Stripe restricted key $39/mo Connect ActiveCampaign and Google Sheets Subscribers, tags, opens and clicks as rows you can pivot You paste: ActiveCampaign API key, Google Sheets link $39/mo Connect Google Sheets and Notion Sheet rows become Notion items, and the status comes back to the row You paste: Google Sheets link, Notion integration secret $39/mo Connect Kommo and Google Sheets Leads, stages and amounts as rows anyone in the office can read You paste: Kommo token, Google Sheets link $39/mo Connect Airtable and HubSpot Airtable records become contacts and deals, changes flow back You paste: Airtable token and base ID, HubSpot private app token $39/mo Connect Jira and Google Sheets Jira filter results as rows that stay current, and a requests tab that opens issues You paste: Jira Cloud API token, Google Sheets link $39/mo Connect Airtable and Slack New and changed Airtable records posted to Slack by view, with one thread per record You paste: Airtable personal access token, Slack bot token $39/mo Connect Slack and Google Sheets New rows and changed cells posted to Slack, with a direct message to the owner column You paste: Slack bot token, Google Sheets link $39/mo Connect HubSpot and Google Sheets A tab per pipeline with a live row per deal, and an import tab that makes contacts You paste: HubSpot private app token, Google Sheets link $39/mo Connect Airtable and Jira Airtable roadmap records become Jira issues, status and story points come back You paste: Airtable personal access token, Jira Cloud API token $39/mo Connect Google Sheets and Mailchimp Rows join the audience with live tag cells, and signups land back as rows You paste: Google Sheets link, Mailchimp API key $39/mo Connect Bitrix24 and Google Sheets Deals and leads as rows, rewritten as the stage and the sum change You paste: Bitrix24 webhook, Google Sheets link $39/mo Connect Ozon and Google Sheets Marketplace orders as rows with status, tracking and stock counts You paste: Ozon Seller key, Google Sheets link $39/mo Connect 1C and Google Sheets Invoices, payments and stock from the books, in a sheet anyone can read You paste: 1C HTTP service address, Google Sheets link $79/mo Connect
Don't see your two apps?

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.

Describe it

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.

PairWhat starts itDirectionWhenPrice
Shopify and Google SheetsNew order as a rowShopify to Google SheetsWithin seconds$39/mo
WooCommerce and Google SheetsNew order as a rowWooCommerce to Google SheetsWithin seconds$39/mo
Google Sheets and StripePayment as a rowStripe to Google SheetsWithin seconds$39/mo
ActiveCampaign and Google SheetsNew subscriber as a rowActiveCampaign to Google SheetsWithin seconds$39/mo
Google Sheets and NotionNew row becomes a pageGoogle Sheets to NotionWithin a minute$39/mo
Kommo and Google SheetsNew lead as a rowKommo to Google SheetsWithin seconds$39/mo
Airtable and HubSpotRecord becomes a contactAirtable to HubSpotWithin seconds$39/mo
Jira and Google SheetsFilter results as rowsJira to Google SheetsWithin seconds$39/mo
Airtable and SlackRecord enters a viewAirtable to SlackWithin a minute$39/mo
Slack and Google SheetsNew rowGoogle Sheets to SlackWithin a minute$39/mo
HubSpot and Google SheetsA tab per pipelineHubSpot to Google SheetsWithin seconds$39/mo
Airtable and JiraRecord in the view becomes an issueAirtable to JiraWhen it appears in the view you nominate$39/mo
Google Sheets and MailchimpRow joins the audienceGoogle Sheets to MailchimpEvery few minutes$39/mo
Bitrix24 and Google SheetsNew deal as a rowBitrix24 to Google SheetsWithin seconds$39/mo
Ozon and Google SheetsNew order as a rowOzon to Google SheetsWithin seconds$39/mo
1C and Google SheetsDocuments as rows1C to Google SheetsA 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.