Skip to content
  • Google Sheets logoGoogle Sheets logo
  • QuickBooks Online logoQuickBooks Online logo
  • Filter by Zapier logoFilter by Zapier logo
  • Google Sheets logoGoogle Sheets logo
  • QuickBooks Online logoQuickBooks Online logo
  • Filter by Zapier logoFilter by Zapier logo

Google Sheets + QuickBooks Online + Filter by Zapier

Google Sheets + QuickBooks Online + Filter by Zapier

Google Sheets + QuickBooks Online integrations

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.

  1. When this happens...
    New or Updated Spreadsheet Row
    New or Updated Spreadsheet Row
    New or Updated Spreadsheet RowTriggers when a new row is added or modified in a spreadsheet.
  2. automatically do this...
    Only continue if...
    Only continue if...
    Only continue if...Set up rules to specify when this Zap can continue running.
  3. then do this!
    Create Sales Receipt
    Create Sales Receipt
    Create Sales ReceiptTriggers when a new sales receipt is added (with line item support).
Start free with email
Start free with email
Google Logo Start free with Google
  • Free forever for core features
  • 14 day trial for premium features & apps

More things you can do with these apps

Discover other triggers and actions you can use with Google Sheets, Filter by Zapier, and more

    • Dont_change_sheet_structure
    • Drive
    • Spreadsheet
      Required
    • Worksheet
      Required
    Trigger
    Polling
    Try It
    • Dont_change_sheet_structure
    • No_team_drive
    • Spreadsheet
      Required
    • Worksheet
      Required
    • Trigger column
    Trigger
    Instant
    Try It
    • Drive
    • Spreadsheet
      Required
    • Worksheet
      Required
    • Column_name
      Required
    • Index
    Action
    Write
    • Dont_change_sheet_structure
    • No_team_drive
    • Spreadsheet
      Required
    • Worksheet
      Required
    Trigger
    Instant
    Try It
    • Dont_change_sheet_structure
    • Drive
    • Spreadsheet
      Required
    • Worksheet
      Required
    • Trigger column
    Trigger
    Polling
    Try It
    • Drive
    • Spreadsheet
      Required
    Trigger
    Polling
    Try It
    • Drive
    • Spreadsheet
      Required
    • Worksheet
      Required
    • Use Timezone set up on the spreadsheet to format date values?
    Action
    Write
google-sheets logo
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Similar apps
Zoho Creator integrationsZoho Creator integrations
Zoho Creator
App Builder, Zoho
Smartsheet integrationsSmartsheet integrations
Smartsheet
Spreadsheets
Quip integrationsQuip integrations
Quip
Documents
quickbooks logo
About QuickBooks Online
QuickBooks Online is the web version of the popular accounting packages QuickBooks. Use any Zapier integration to connect QuickBooks Online to hundreds of other apps.
Related categories
Similar apps
Xero integrationsXero integrations
Xero
Accounting
FreeAgent integrationsFreeAgent integrations
FreeAgent
Accounting
Wave integrationsWave integrations
Wave
Accounting
filter logo
About Filter by Zapier
Only allow a Zap to proceed when a certain condition is met. For example, if you're sending a text message when you receive a new email, you could use a Filter that only sends a text message when the email received is from a certain address.
Related categories

Related Zap Templates