Google Sheets + QuickBooks Online + Filter by Zapier
Create Sales Receipts and customers in QuickBooks Online for updated rows in Google Sheets
You can process accounting transactions even from within a spreadsheet. Once this integration is on, it will trigger with new spreadsheet row updates, optionally using a filter for specific columns/values. We'll then find or create a customer in QuickBooks for each matching update, and attach a sales receipt to them with the data from Google Sheets.
You can process accounting transactions even from within a spreadsheet. Once this integration is on, it will trigger with new spreadsheet row updates, optionally using a filter for specific columns/values. We'll then find or create a customer in QuickBooks for each matching update, and attach a sales receipt to them with the data from Google Sheets.
- When this happens...New or Updated Spreadsheet Row
Triggered when a new row is added or modified in a spreadsheet.
- automatically do this...Only continue if...
Set up rules to specify when this Zap can continue running.
- then do this!Create Sales Receipt
Triggered when a new sales receipt is added (with line item support).
- Free forever for core features
- 14 day trial for premium features & apps
