Skip to main content

Documentation Index

Fetch the complete documentation index at: https://newie.mintlify.app/llms.txt

Use this file to discover all available pages before exploring further.

​
Why Connect Newie + Google Sheets

For operators who want a simple, queryable log of every Newie event without paying for a BI tool. A Google Sheet is the easiest “lightweight CRM” - one tab for customers, one for payments - and gives finance, ops, or a VA somewhere to filter and pivot.

​
Common Zaps

Subscription Started → Google Sheets: Create Spreadsheet Row Append a row to a “Customers” sheet with name, email, service, and active start date when the first subscription payment is complete. Payment Paid → Google Sheets: Create Spreadsheet Row Append a row to a “Payments” sheet for every successful payment - useful for monthly revenue snapshots and cross-checks against your accounting tool. For BECS Direct Debit, this row is created after bank confirmation, not at initial payment submission. Payment Overdue → Google Sheets: Create Spreadsheet Row Log overdue invoices to a dedicated tab so someone can work the list daily. Subscription Ends → Google Sheets: Update Spreadsheet Row Use Lookup Spreadsheet Row first to find the customer in the Customers sheet, then update an “End Date” column so the row reflects current status.

​
What You’ll Need

  • Newie account with Zapier connected (Settings → Integrations → Zapier)
  • A Google account with access to the target spreadsheet
  • A spreadsheet with column headers already in place; Zapier maps to existing headers, so create them before building the Zap

​
Setup at a Glance

  1. In Newie, go to Settings → Integrations → Zapier and copy your API token.
  2. In Zapier, create a new Zap and choose Newie as the trigger. Pick the trigger event (e.g. Payment Paid, Subscription Started, or One-Off Purchase Complete).
  3. Connect Google Sheets as the action app and authorize.
  4. Choose Create Spreadsheet Row.
  5. Select the spreadsheet and worksheet, then map Newie fields to each column header.
  6. Test, then enable.
See Connecting Newie to Zapier for setup details.

​
Notes

  • Don’t rename spreadsheet headers once the Zap is live without remapping the Zap fields.
  • For high-volume accounts, consider a single “Events” sheet with a Type column rather than one tab per Newie trigger; it’s easier to pivot.
  • Google Sheets has a spreadsheet cell limit, not a fixed row limit. More columns mean fewer possible rows, and very large sheets can become slow before they hit the limit. For long-lived logs, archive older rows to a separate file periodically.
Last updated: 30 May 2026