How to Integrate FreshBooks with Google Sheets

‍

‍

In this tutorial, you’ll learn how to automatically sync your FreshBooks data to Google Sheets using Zapier to streamline your business reporting.

‍

1. Log in to your Zapier account and select Create Zap.
2. Click Trigger and search for FreshBooks.
3. Select FreshBooks as your Trigger.
4. Select New Invoice (or New Expense if tracking costs).
5. Click Continue.
6. Select which account to use before continuing.
7. Click Test Trigger to run a quick test to confirm everything connects properly.
8. Select which record to use before clicking Continue with selected record.
9. Select Google Sheets as the action app.
10. Select Create Spreadsheet Row.
11. Click Continue.
12. Select which drive to use, the spreadsheet, and your preferred worksheet.
13. Click Continue after completing the field.
14. Click the Test step button at the bottom right of the mapping screen.
15. In the lower right corner, click the Publish button to activate the sync.