Refound your company for the AI era at ZapConnect 2026. Save your spot →
FreshBooks + Google Sheets integrations
Add FreshBooks clients from new rows on Google Sheets
Capturing new customer info on a spreadsheet? Don't bother with manual exports from there, we'll do it for you. Once this Google Sheets to FreshBooks integration has been set up, all new Google Sheets spreadsheet rows added from that point forward will be copied to FreshBooks, ensuring your lists are always updated.
How this Google Sheets-FreshBooks integration works
- A new contact or client record is added to a Google Sheets spreadsheet
- Zapier copies the contact to your FreshBooks account
Apps involved
- Google Sheets
- FreshBooks
- When this happens...

New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.TriggerInstant - automatically do this!

Create ClientCreates a new client.ActionWrite
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with Google Sheets and FreshBooks
Discover other triggers and actions you can use with Google Sheets and FreshBooks
Triggers
Actions
Triggers & Actions
- Dont_change_sheet_structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Dont_change_sheet_structure
- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Condition TypeRequired
- Background Color
- Text Color
- Bold Text
- Italic Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- SpreadsheetRequired
- WorksheetRequired
- New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Sort by ColumnRequired
- Sort OrderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- First row
- Row count
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
ActionThis is an event a Zap performs.SearchFind existing data in your app- Spreadsheet IDRequired
- Include Grid Data
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- Spreadsheet NameRequired
- Search Type
- Spreadsheet to Copy
- Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- AccountRequired
- AmountRequired
- Date
- Invoice IDRequired
- Payment Type
- Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- Item IDRequired
- PriceRequired
- CurrencyRequired
- Tax Amount
- Tax Name
- Send Admin Receipt?Required
- Note
- Is Active?
- Terms and Conditions
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- Client IDRequired
- Credit Type
- Credit Number
- Currency Code
- Date of Issue
- Notes
- Terms
- Language
- Name
- Line Item Description
- Line Item Quantity
- Tax 1 Name
- Tax 1 Amount
- Tax 2 Name
- Tax 2 Amount
- Compounded Tax
- Unit Cost
- Currency Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- AmountRequired
- CategoryRequired
- Client
- Date
- Notes
- Staff MemberRequired
- Tax1 Amount
- Tax1 Percent
- Tax1 Name
- Tax2 Amount
- Tax2 Name
- Tax2 Percent
- Compounded Tax
- Currency
- Vendor
- Duplicate Estimate?
- Account Name
- Transaction Id
- Invoice Id
- Status
- Bank Name
- External System ID
- Has Receipt?
- Background Job ID?
- External Invoice ID
- Markup Percent
- Project
- Profile ID
- Visibility State
- Account System ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- InvoiceRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- TitleRequired
- Client ID
- Due Date
- Project Type
- Fixed Price
- Rate
- Budget
- Active
- Complete
- Billable
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- Project
- Task
- Started AtRequired
- Created At
- DurationRequired
- Is LoggedRequired
- Internal?
- Client IDRequired
- Billed?
- Billable?
- Active?
- Pending Client
- Pending Project
- Pending Task
- Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- Checkout Link IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- Email Body
- Email SubjectRequired
- Invoice IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- Checkout Link IDRequired
- Item IDRequired
- AmountRequired
- CurrencyRequired
- Note
- Is Active?Required
- Send Admin Receipt?Required
- Tax Amount
- Tax Name
- Item NameRequired
- Terms and Conditions
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- Client IDRequired
- Credit Note IDRequired
- Credit Number
- Currency Code
- Date of Issue
- Notes
- Terms
- Language
- Name
- Line Item Description
- Line Item Quantity
- Tax 1 Name
- Tax 1 Amount
- Tax 2 Name
- Tax 2 Amount
- Compounded Tax
- Unit Cost
- Currency Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- Client
- Create if Invoice Does Not ExistRequired
- Append Line Items on UpdateRequired
- Currency Code
- Date of Issue
- Days Due From Issue
- Invoice NumberRequired
- Language
- Estimate
- Active Payment Gateway
- Line Item Description
- Line Item NameRequired
- Line Item QuantityRequired
- Line Item Tax1 Name
- Line Item Tax1 Percent
- Line Item Unit CostRequired
- Notes
- PO Number
- Terms
- Discount Amount
- Discount Description
- Body
- Delay
- Days
- Late Fee Percentage or Amount
- Repeat Late Fee
- Late Fee Type
- First Tax Name
- First Tax Percent
- Second Tax Name
- Second Tax Percent
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- Vendor IDRequired
- Vendor Name
- Contact First Name
- Contact Last Name
- Contact Email
- Street
- City
- Province
- Postal Code
- Country
- Account Number
- Phone
- Website
- Currency Code
- Language
- Is 099
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- Credit Note ID
ActionThis is an event a Zap performs.SearchFind existing data in your app- AccountRequired
- Search FieldRequired
- Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- AccountRequired
- Search FieldRequired
- Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- AccountRequired
- Search FieldRequired
- Search ValueRequired
- VendorRequired
- Currency CodeRequired
- Date of Issue
- Days Due From Issue
- Bill Number
- LanguageRequired
- Description
- QuantityRequired
- Tax Name
- Tax Percent
- RateRequired
- Expense CategoryRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- AccountRequired
- Search FieldRequired
- Search ValueRequired
- EmailRequired
- First Name
- Home Phone
- Language
- Last Name
- Notes
- Organization
- Primary City
- Primary Country
- Primary State
- Primary Street 1
- Primary Street 2
- Primary Zip Code
- VAT Name
- VAT Number
- Work Phone
- Currency_code
- Quantity
- Unit Cost
- Description
- Credit_note_create_date
- Credit_note_credit_type
- Body
- Delay
- Days
- Late Fee Percentage or Amount
- Repeat Late Fee
- Late Fee Type
- First Tax Name
- First Tax Percent
- Second Tax Name
- Second Tax Percent
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- AccountRequired
- Search FieldRequired
- Search ValueRequired
- ClientRequired
- Currency Code
- Date of Issue
- Days Due From Issue
- Line Item Description
- Line Item NameRequired
- Line Item QuantityRequired
- Line Item Tax1 Name
- Line Item Tax1 Percent
- Line Item Unit CostRequired
- Active Payment Gateway
- Notes
- Invoice Paid?
- Terms
- Discount Amount
- Discount Description
- Invoice Number
- PO Number
- Language
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- AccountRequired
- Search FieldRequired
- Search ValueRequired
- Vendor NameRequired
- Contact First Name
- Contact Last Name
- Contact Email
- Street
- City
- Province
- Postal Code
- Country
- Account Number
- Phone
- Website
- Currency Code
- Language
- Is 1099 Contractor
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
- Dont_change_sheet_structure
- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Dont_change_sheet_structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Dont_change_sheet_structure
- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column_nameRequired
- Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Source RangeRequired
- Destination RangeRequired
- Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- TitleRequired
- Spreadsheet to Copy
- Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Validation TypeRequired
- Input Message
- Strict Validation
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Overwrite All Columns
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Api_docs_info
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- Spreadsheet NameRequired
- Search Type
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- AccountRequired
- StatusRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- AccountRequired
- VendorRequired
- Currency CodeRequired
- Date of Issue
- Days Due From Issue
- Bill Number
- LanguageRequired
- Description
- QuantityRequired
- Tax Name
- Tax Percent
- RateRequired
- Expense CategoryRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- EmailRequired
- First Name
- Home Phone
- Language
- Last Name
- Notes
- Organization
- Primary City
- Primary Country
- Primary State
- Primary Street 1
- Primary Street 2
- Primary Zip Code
- VAT Name
- VAT Number
- Work Phone
- Currency_code
- Quantity
- Unit Cost
- Description
- Credit_note_create_date
- Credit_note_credit_type
- Body
- Delay
- Days
- Late Fee Percentage or Amount
- Repeat Late Fee
- Late Fee Type
- First Tax Name
- First Tax Percent
- Second Tax Name
- Second Tax Percent
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- CustomerRequired
- Create DateRequired
- Estimate Number
- Organization
- First Name
- Last Name
- Visibility State
- Discount Value
- Currency Code
- Language
- Terms
- Address
- PO Number
- Street
- Street 2
- City
- Province
- Zip Code
- Country
- Estimate
- Sent ID
- Value Added Tax Name
- Value Added Tax Number
- Notes
- Name
- Description
- Type
- Quantity
- Unit Cost Amount
- Unit Cost Code
- Tax Name 1
- Tax Amount 1
- Tax Name 2
- Tax Amount 2
- Send to Customer?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- ClientRequired
- Currency Code
- Date of Issue
- Days Due From Issue
- Line Item Description
- Line Item NameRequired
- Line Item QuantityRequired
- Line Item Tax1 Name
- Line Item Tax1 Percent
- Line Item Unit CostRequired
- Active Payment Gateway
- Notes
- Invoice Paid?
- Terms
- Discount Amount
- Discount Description
- Invoice Number
- PO Number
- Language
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- AmountRequired
- Amount CodeRequired
- Category NameRequired
- AmountRequired
- NameRequired
- Date
- Note
- Payment Type
- Source
- Visibility State
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- ClientRequired
- Currency Code
- Date of Issue
- Days Due From Issue
- Line Item Description
- Line Item NameRequired
- Line Item QuantityRequired
- Line Item Tax1 Name
- Line Item Tax1 Percent
- Line Item Unit CostRequired
- Active Payment Gateway
- Notes
- Terms
- Discount Amount
- Discount Description
- Invoice Number
- PO Number
- Language
- FrequencyRequired
- Is Infinite?Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- Vendor NameRequired
- Contact First Name
- Contact Last Name
- Contact Email
- Street
- City
- Province
- Postal Code
- Country
- Account Number
- Phone
- Website
- Currency Code
- Language
- Is 1099 Contractor
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- Email_recipientsRequired
- Email BodyRequired
- Email SubjectRequired
- EstimateRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- Bill IDRequired
- Vendor
- Currency Code
- Date of Issue
- Days Due From Issue
- Bill Number
- Language
- Description
- QuantityRequired
- Tax Name
- Tax Percent
- RateRequired
- Expense CategoryRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- Create if Client Does Not ExsistRequired
- EmailRequired
- First Name
- Home Phone
- Language
- Last Name
- Mobile Phone
- Notes
- Organization
- Primary City
- Primary Country
- Primary State
- Primary Street 1
- Primary Street 2
- Primary Zip Code
- VAT Name
- VAT Number
- Work Phone
- Currency_code
- Quantity
- Unit Cost
- Description
- Credit_note_create_date
- Credit_note_credit_type
- Body
- Delay
- Days
- Late Fee Percentage or Amount
- Repeat Late Fee
- Late Fee Type
- First Tax Name
- First Tax Percent
- Second Tax Name
- Second Tax Percent
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- Create if Estimate Does Not ExistRequired
- Customer
- Create Date
- Estimate Number
- Organization
- First Name
- Last Name
- Visibility State
- Discount Value
- Currency Code
- Language
- Terms
- Address
- PO Number
- Street
- Street 2
- City
- Province
- Zip Code
- Country
- Estimate ID
- Sent ID
- Value Added Tax Name
- Value Added Tax Number
- Notes
- Name
- Description
- Type
- Quantity
- Unit Cost Amount
- Unit Cost Code
- Tax Name 1
- Tax Amount 1
- Tax Name 2
- Tax Amount 2
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- Time Entry IDRequired
- Project
- Started At
- Duration
- Is Logged
- Internal?
- Client ID
- Billed?
- Billable?
- Active?
- Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- AccountRequired
- Search FieldRequired
- Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- AccountRequired
- Search FieldRequired
- Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- AccountRequired
- Search FieldRequired
- Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- AccountRequired
- Search FieldRequired
- Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- AccountRequired
- Credit Note ID
- Client IDRequired
- Credit Type
- Credit Number
- Currency Code
- Date of Issue
- Notes
- Terms
- Language
- Name
- Line Item Description
- Line Item Quantity
- Tax 1 Name
- Tax 1 Amount
- Tax 2 Name
- Tax 2 Amount
- Compounded Tax
- Unit Cost
- Currency Code
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- AccountRequired
- Search FieldRequired
- Search ValueRequired
- CustomerRequired
- Create DateRequired
- Estimate Number
- Organization
- First Name
- Last Name
- Visibility State
- Discount Value
- Currency Code
- Language
- Terms
- Address
- PO Number
- Street
- Street 2
- City
- Province
- Zip Code
- Country
- Estimate
- Sent ID
- Value Added Tax Name
- Value Added Tax Number
- Notes
- Name
- Description
- Type
- Quantity
- Unit Cost Amount
- Unit Cost Code
- Tax Name 1
- Tax Amount 1
- Tax Name 2
- Tax Amount 2
- Send to Customer?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- AccountRequired
- Search FieldRequired
- Search ValueRequired
- TitleRequired
- Client ID
- Due Date
- Project Type
- Fixed Price
- Rate
- Budget
- Active
- Complete
- Billable
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
FreshBooks is a cloud accounting software designed exclusively for self-employed professionals and their teams. Send invoices, track expenses, manage your time, and collaborate on projects.
Related categories
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Related Zap Templates
- Add new Google Sheets spreadsheet rows to FreshBooks as new clients
- Send new form submissions in HubSpot to Google Sheets and create new clients in Freshbooks
- Add new FreshBooks expenses to Google Sheets as rows
- Add new Google Sheets rows to FreshBooks as clients or update existing ones
- Create or update FreshBooks clients from new or updated Google Sheets rows




