Billed + Google Sheets
Create expenses in Billed from new rows in Google Sheets
Track your expenditures more effectively with this streamlined workflow. Once a new row is added to your Google Sheets, an expense is instantly created in Billed. This makes financial management more efficient and ensures that every expenditure is systematically recorded in real time. It's an easy way to optimize your bookkeeping process, saving you both time and stress.
Track your expenditures more effectively with this streamlined workflow. Once a new row is added to your Google Sheets, an expense is instantly created in Billed. This makes financial management more efficient and ensures that every expenditure is systematically recorded in real time. It's an easy way to optimize your bookkeeping process, saving you both time and stress.
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create an ExpenseThis will creates an expense record.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNo 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.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 appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
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
Delete Client
Triggers when a client is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Delete Expense
Triggers when an expense is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Delete Item
Triggers when an item is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Delete Project
Triggers when a project is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Delete Timelog
Triggers when a timelog is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Edit Estimate
Triggers when an estimate is edited.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Edit Invoice
Triggers when an invoice is edited.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Edit Payment
Triggers when a payment is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Edit Task
Triggers when a task is edited.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Client
Triggers when a new client is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Expense
Triggers when an expense is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Invoice
Triggers when an invoice is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Payment
Triggers when a payment is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Task
Triggers when a task is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Client IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Expense IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Item IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Timelog IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Template IDRequired
Discount IDRequired
Discount AmountRequired
Tax TypeRequired
Tax AmountRequired
Tax LabelRequired
Tax Prices IncludedRequired
ClientRequired
Total Estimate AmountRequired
Item Purchase PriceRequired
Item Selling PriceRequired
Item QuantityRequired
Item TitleRequired
Item TotalsRequired
Item Discount IdRequired
Item Discount AmountRequired
Item Tax IdRequired
Item Tax AmountRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Template IDRequired
Discount TypeRequired
Discount AmountRequired
Tax TypeRequired
Tax AmountRequired
Tax LabelRequired
Tax Prices IncludedRequired
ClientRequired
Item Purchase PriceRequired
Item Selling PriceRequired
Item QuantityRequired
Item TitleRequired
Item TotalsRequired
Item Discount IdRequired
Item Discount AmountRequired
Item Tax IdRequired
Item Tax AmountRequired
Total Invoice Discount
Total Invoice Tax
Total Invoice AmountRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Payment AmountRequired
InvoiceRequired
Payment MethodRequired
Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task TitleRequired
ProjectRequired
Task Priority
Estimate Budget
Estimate TIme
Task notes
Mark Completed
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Timelog IDRequired
End TimestampRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Estimate IDRequired
Template ID
Discount Type
Discount Amount
Tax Type
Tax Amount
Tax Label
Tax Prices Included
Client
Total Estimate Amount
Item Purchase Price
Item Selling Price
Item Quantity
Item Title
Item Totals
Item Discount Id
Item Discount Amount
Item Tax Id
Item Tax Amount
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Invoice IDRequired
Template ID
Discount Type
Discount Amount
Tax Type
Tax Amount
Tax Label
Tax Prices Included
Client
Total Invoice Discount
Total Invoice Tax
Invoice Total Amount
Item Purchase Price
Item Unit Cost
Item Quantity
Item Title
Item Total
Item Discount ID
Item Discount Amount
Item Tax ID
Item Tax Amount
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
Payment Amount
Invoice
Payment Method
Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task IDRequired
Task Title
Task Priority
Estimate Budget
Estimate Time
Task notes
Mark Completed
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
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 appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
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 appDrive
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 foundDelete Estimate
Triggers when an estimate is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Delete Invoice
Triggers when an invoice is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Delete Payment
Triggers when a payment is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Delete Task
Triggers when a task is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Edit Client
Triggers when a client is edited.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Edit Expense
Triggers when an expense is edited.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Edit Item
Triggers when an item is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Edit Project
Triggers when a project is edited.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Edit Timelog
Triggers when a timelog is edited.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Estimate
Triggers when an estimate is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Expense Category
Triggers when a expense category is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Item
Triggers when a new item is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Project
Triggers when a project is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Timelog
Triggers when a timelog is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Estimate IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Invoice IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Payment IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Client NameRequired
Phone
Mobile
Fax Address
Email Address
Address Line
Address Line
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Merchant DetailsRequired
Image Attachment
Billable to client
Total ExpenseRequired
CategoryRequired
Client
Description
Expense TimestampRequired
Grand TotalsRequired
Add Markup
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Item TitleRequired
Description
Selling PriceRequired
Purchase PriceRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project TitleRequired
Hourly RateRequired
Is Billable
Project Client
Project Notes
Project Progress EstimateRequired
Is Task Based EstimateRequired
Estimate Amount
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Billable
Description
ProjectRequired
TaskRequired
Start TimestampRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
Client Name
Phone
Mobile
Fax Address
Email Address
Address Line
Address Line
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
Merchant Details
Image Attachment
Billable to client
Total Expense
Category
Client
Description
Expense Timestamp
Grand Total
Add Markup
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Item Title
Description
Selling Price
Purchase Price
Item IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
Project Title
Hourly Rate
Is Billable
Project Client
Project Notes
Project Progress Estimate
Is Task Based Estimate
Estimate Amount
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Timelog IDRequired
Billable
Description
Start Timestamp
End Timestamp
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
About Billed
Related categories
