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.
- When this happens...

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

Create an ExpenseThis will creates an expense record.ActionWrite
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with Google Sheets and Billed
Discover other triggers and actions you can use with Google Sheets and Billed
- 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
- Include Grid Data
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
Delete ClientTriggers when a client is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Delete ExpenseTriggers when an expense is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Delete ItemTriggers when an item is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Delete ProjectTriggers when a project is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Delete TimelogTriggers when a timelog is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Edit EstimateTriggers when an estimate is edited.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Edit InvoiceTriggers when an invoice is edited.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Edit PaymentTriggers when a payment is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Edit TaskTriggers when a task is edited.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New ClientTriggers when a new client is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New ExpenseTriggers when an expense is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New InvoiceTriggers when an invoice is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New PaymentTriggers when a payment is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New TaskTriggers 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.
- 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
Delete EstimateTriggers when an estimate is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Delete InvoiceTriggers when an invoice is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Delete PaymentTriggers when a payment is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Delete TaskTriggers when a task is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Edit ClientTriggers when a client is edited.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Edit ExpenseTriggers when an expense is edited.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Edit ItemTriggers when an item is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Edit ProjectTriggers when a project is edited.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Edit TimelogTriggers when a timelog is edited.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New EstimateTriggers when an estimate is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New Expense CategoryTriggers when a expense category is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New ItemTriggers when a new item is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New ProjectTriggers when a project is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New TimelogTriggers 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.




