How to connect FreshBooks + Google Sheets + Slack
Zapier lets you send info between FreshBooks and Google Sheets and Slack automatically—no code required. With 8,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with FreshBooks + Google Sheets + Slack
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with FreshBooks, Google Sheets, and Slack. And don’t forget that you can add more apps and actions to create complex workflows.
- 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
- 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 
- 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 
- 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.
- 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 
- 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 
 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
- Trigger for Bot Messages? 
- Optimized data 
 Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
- ChannelRequired 
- Trigger for Bot Messages? 
- Optimized data 
 Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
- Channel 
- User Name 
- Shared 
 Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
- Search QueryRequired 
- Optimized data 
 Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
- Conversation ID 
- Reaction 
- Member ID 
- Message Author ID 
 Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
- Zap Identifier 
- Access type 
 Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
 - New User- Triggers when a new Slack user is created / first joins your org. Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
- Conversation IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- ChannelRequired 
- UsersRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Allowed Delete Copy 
- Conversation IDRequired 
- Message TS (ID)Required 
- Posted By 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Allowed Edit Copy 
- Conversation IDRequired 
- Message TS (ID)Required 
- Posted By 
- Content Type 
- Reply Broadcast 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- ChannelRequired 
- Add Zapier app to channel automatically? 
- Message TextRequired 
- Send as a bot? 
- Bot Name 
- Bot Icon 
- Include a link to this Zap? 
- Attach Image by URL 
- Auto-Expand Links? 
- Link Usernames and Channel Names? 
- Schedule At 
- Zap Id 
- File 
- Thread 
- Send Channel Message? 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- ChannelRequired 
- TopicRequired 
- Topic set by 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Status Text 
- Status Emoji 
- Expiration Time 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
 - Remove User from Channel- This action removes a specified user from a specified channel in Slack. ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
 - Edit Message- This action updates a specific message sent by the same Authenticated user on Slack. You need to provide the Channel ID, the Timestamp of the message to be edited, and the new text for the message. ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
 - Find Public Channel- This action will find a public channel in Slack using either the channel's ID or name. ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
 - Delete Message- This action deletes an existing message in a specific channel on Slack. You need to provide the channel ID and the message timestamp as inputs. ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Conversation IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Conversation IDRequired 
- Message ID (ts)Required 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Search QueryRequired 
- Sort By 
- Sort Direction 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- IDRequired 
- Return Raw Results? 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- UsernameRequired 
- Return Raw Results? 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- 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
- 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 
- Row count 
 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 
- 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
 - New Channel- Triggers when a new #channel is created. Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
- Username 
- Highlight Word 
- Trigger for Bot Messages? 
- Only Public Channels? 
 Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
- ChannelRequired 
- Trigger for Bot Messages? 
 Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
 - New Saved Message- Triggers when you save a message. Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
- TextRequired 
- Remind when?Required 
- Remind who? 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Conversation IDRequired 
- Scheduled AsRequired 
- Scheduled Message IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- ChannelRequired 
- Add Zapier app to channel automatically? 
- Message TextRequired 
- Send as a bot? 
- Bot Name 
- Bot Icon 
- Include a link to this Zap? 
- Attach Image by URL 
- Auto-Expand Links? 
- Link Usernames and Channel Names? 
- Schedule At 
- File 
- Thread 
- Send Channel Message? 
- Zap Id 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Send Multi Message 
- Message TextRequired 
- Send as a bot? 
- Include a link to this Zap? 
- Attach Image by URL 
- Auto-Expand Links? 
- Link Usernames and Channel Names? 
- Schedule At 
- Zap Id 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Channel NameRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Status Copy 
- Approval request messageRequired 
- Send message asRequired 
- Approval typeRequired 
- Zap Id 
- Include a link to this Zap? 
- Approve button URL 
- Approve button label 
- Add decline button 
- Add details button 
- Require confirmation 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- First Name 
- Last Name 
- Title 
- Email 
- Display Name 
- User 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- 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.
 - Get Message by Timestamp- This action retrieves a specific message from a conversation history in Slack using the message's timestamp. ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
 - Retrieve Thread Messages- This action retrieves all the messages sent to a specific thread in a selected channel. ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
 - Create Private Channel- This action creates a private channel in Slack. ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Conversation IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Conversation IDRequired 
- Message ID (ts)Required 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Conversation IDRequired 
- Message TS (ID)Required 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- EmailRequired 
- Return Raw Results? 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Full NameRequired 
- Return Raw Results? 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
Top companies trust Zapier to automate work and free up time
Join millions worldwide who automate their work using Zapier
How FreshBooks + Google Sheets + Slack Integrations Work
- Step 1: Authenticate FreshBooks, Google Sheets, and Slack.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.






















