Connect Google Sheets and QuickBooks integrations
Connect Google Sheets and QuickBooks with any of your favorite apps in just a few clicks. Design, build, and automate anything for your work by integrating apps like Google Sheets and QuickBooks to create visual automated workflows. Choose from thousands of ready-made apps or use our no-code toolkit to connect to apps not yet in our library.
Receives data from the MAKE_FUNCTION or INTEGROMAT functions used in a sheet. Please note, the Sheets Add-On is required.
Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.
Triggers when a new row is added.
Creates a bill.
Creates a credit card payment.
Creates a credit memo.
Creates a customer.
Creates a deposit.
Creates a journal entry.
Creates an account.
Creates an estimate.
Creates an invoice.
Creates an item.
Creates a payment.
Creates a purchase.
Creates a purchase order.
Creates a refund receipt.
Creates a sales receipt.
Creates a note.
Creates a time activity.
Creates a vendor.
Deletes a bill.
Deletes a credit memo.
Deletes a deposit.
Deletes a journal entry.
Deletes an attachment.
Deletes an estimate.
Removes an invoice.
Deletes a payment.
Deletes a purchase.
Deletes a purchase order.
Deletes a refund receipt.
Deletes a sales receipt.
Deletes a time activity.
Downloads a file.
Downloads an estimate.
Downloads an invoice.
Downloads a payment.
Downloads a sales receipt.
Returns info about a bill.
Returns info about a credit memo.
Returns info about a customer.
Returns info about a deposit.
Returns info about a journal entry.
Returns info about an account.
Returns info about an estimate.
Returns info about an invoice.
Returns info about an item.
Returns info about a payment.
Returns info about a purchase.
Returns details about a purchase order.
Returns info about a refund receipt.
Returns details about a sales receipt.
Returns info about an activity.
Returns info about a vendor.
Returns info about a company.
Performs an arbitrary authorized API call.
Sends an estimate.
Sends an invoice.
Sends a sales receipt.
Updates a bill.
Updates a credit memo.
Updates a customer.
Updates a deposit.
Updates a journal entry.
Updates an account.
Updates an estimate.
Updates an invoice.
Updates an item.
Updates a payment.
Updates a purchase.
Updates a purchase order.
Updates a refund receipt.
Updates a sales receipt.
Updates a time activity.
Updates a vendor.
Uploads a file.
Searches for accounts.
Searches for attachments.
Searches for bills.
Searches for credit memos.
Searches for customers.
Searches for deposits.
Searches for estimates.
Searches for invoices.
Searches for items.
Searches for journal entries.
Searches for payments.
Searches for a purchase order.
Searches for purchases.
Searches for refund receipts.
Searches for sales receipts.
Searches for time activities.
Searches for vendors.
Trusted by thousands of fast-scaling organizations around the globe
Automate your work. Build something new.
Just drag and drop apps to automate existing workflows or build new complex processes. Solve problems across all areas and teams.
Build your Google Sheets and QuickBooks integrations.
Create custom Google Sheets and QuickBooks workflows by choosing triggers, actions, and searches. A trigger is an event that launches the workflow, an action is the event.
Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.
Appends a new row to the bottom of the table.
Adds a new sheet.
Appends multiple rows to the bottom of the table.
Updates multiple rows.
Clears a specified range of values from a spreadsheet.
Clears a specific cell.
Clears values from a specific row.
Copies a sheet to another spreadsheet.
Connect any app with Google Sheets and QuickBooks
Popular Google Sheets and QuickBooks workflows.
Looking to get more out of Google Sheets and QuickBooks? With Make you can visually integrate Google Sheets and QuickBooks into any workflow to save time and resources — no coding required. Try any of these templates in just a few clicks.
Update Inventory values in QuickBooks & Google Sheets for new WooCommerce orders
Every time a new order is created in WooCommerce, Make will automatically update the inventory values in QuickBooks and Google Sheets. The template uses [this example spreadsheet]( https://docs.google.com/spreadsheets/d/1p6ua_qmTJb2XZtIHM_fPf2Amwb9BKXJ_c7EUegT-vMQ/edit?usp=sharing).
TRY IT ->Create a sales receipt in QuickBooks from customer details in a Google Sheets spreadsheet.
Every time a customer's details are added to a Google Sheet, Make retrieves the info and creates a sales receipt in QuickBooks. If its a new customer, the customer is first added to QuickBooks and then a receipt is created. The template uses this [example spreadsheet.](https://docs.google.com/spreadsheets/d/1Ie8njl21Ob0cyugwb4qg_HIX53qsJAeph2vrLxvq9ww/edit#gid=0/xxx)
TRY IT ->Save new QuickBooks customers to a Google Sheets spreadsheet
Every time a new customer is created in QuickBooks, Make will automatically add that customer's info to a new row in your Google Sheets spreadsheet. The template uses this [example spreadsheet]( https://docs.google.com/spreadsheets/d/1e0Tl8oaEQ8YF4HB-kJqu59vpfBocQqGg55gmxfweiBI/edit#gid=0/xxx)
TRY IT ->Save new QuickBooks invoices to a Google Sheets spreadsheet
Every time a new invoice is created or updated in QuickBooks, Make will automatically add that invoice's info to a new row in your Google Sheets spreadsheet.
TRY IT ->Create BKP and FIK codes from new Google Sheets spreadsheet rows and send them to customers via Twilio
Every time you add a new row to your Google Sheets spreadsheet, Make will automatically send a registered sale data message using the EET module and update the spreadsheet with obtained BKP and FIK codes. Both codes will be then sent to your customer via Twilio. The template uses Sheet 2 in this [example spreadsheet](https://goo.gl/F4MLEq).
TRY IT ->Create a Taxpayer's Signature Code (PKP) from new Google Sheets rows and post it to Slack
Every time you add a new row to your Google Sheets spreadsheet, Make will automatically generate a Taxpayer's Signature Code (PKP) using the EET module and post it to Slack. The template uses this [example spreadsheet](https://goo.gl/qm1mgb).
TRY IT ->Generate ChatGPT Completions from Google Sheets Rows
Effortlessly enhance your content creation process by integrating ChatGPT with Google Sheets. This powerful template allows you to automatically generate relevant completions, ranging from SEO keywords to custom responses, boosting productivity and content quality with ease. [Learn more](https://community.make.com/t/getting-started-with-openai-gpt-3-and-make/7796?utm_source=make&utm_medium=in-app&utm_campaign=template)
TRY IT ->Add webhook data to a Google Sheet
Use this automation to instantly capture data from a webhook and automatically add it as a new row in a Google Sheet. This is ideal for real-time data logging, form submissions, or any event-driven updates that must be stored in a spreadsheet. [Learn more about webhooks!](https://www.make.com/en/help/tools/webhooks)
TRY IT ->Sync Facebook Lead Ads leads with Google Sheets
Seamlessly capture and organize new Facebook Lead Ads leads by automatically adding them to a Google Sheets spreadsheet. Streamline your lead management process and enhance productivity with this efficient automation solution.
TRY IT ->
FAQ
How it works
Traditional no-code iPaaS platforms are linear and non-intuitive. Make allows you to visually create, build, and automate without limits.
Trusted by 500,000+ Makers
"Make really helped us to scale our operations, take the friction out of our processes, reduce costs, and relieved our support team. It is difficult to not become a fan."
"Make drives unprecedented efficiency within our business in ways we never imagined. It’s having an extra employee (or 10) for a fraction of the cost."
"The simplicity, flexibility and ability to build real complex automations without any knowledge of programming makes it the best thing since sliced bread."
"True citizen development in the entire company. Make is present in every department, empowering the company to offer a unique customer experience."