Google Sheets + Qoyod
Create new rows in Google Sheets for new invoices in Qoyod
When a new invoice arrives in the Qoyod app, this workflow transposes those details into a Google Sheets row. Enhance your financial tracking efficiency with this automatic system, eliminating the need for manual data entry. It's a simple yet effective way of making sure every invoice is accounted for in your spreadsheets, saving you valuable time and reducing the chance of errors.
When a new invoice arrives in the Qoyod app, this workflow transposes those details into a Google Sheets row. Enhance your financial tracking efficiency with this automatic system, eliminating the need for manual data entry. It's a simple yet effective way of making sure every invoice is accounted for in your spreadsheets, saving you valuable time and reducing the chance of errors.
- When this happens...
New Invoicetriggers when a new invoice is created
TriggerScheduledZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
New Bill
Triggers when a bill is created
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Customer
Triggers when a new customer is created
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Invoice
triggers when a new invoice is created
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Product
New Product is created
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Purchase Order
Triggers when a new Purchase Order is created
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Receipt
Triggers when a receipt is created
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Task
Triggers when a new task is created
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDescription
Issue dateRequired
Due DateRequired
Vendor IDRequired
ReferenceRequired
Product id
Product SKU
Unit PriceRequired
QuantityRequired
Location IDRequired
Discount Type
Discount (percentage or value, depending on type)
Tax
Is Tax Inclusive?Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Description
Issue dateRequired
Due DateRequired
Customer IdRequired
ReferenceRequired
Product id
Product SKU
Unit PriceRequired
QuantityRequired
Location IDRequired
Discount Type
Discount (percentage or value, depending on type)
Tax
Is Tax Inclusive?Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Description
Issue dateRequired
Due DateRequired
Vendor IDRequired
ReferenceRequired
Product Id
Product SKU
Unit PriceRequired
QuantityRequired
Location IDRequired
Discount Type
Discount (percentage or value, depending on type)
Tax
Is Tax Inclusive?Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Description
Issue dateRequired
Due dateRequired
Customer idRequired
ReferenceRequired
Product id
Product SKU
Unit PriceRequired
QuantityRequired
Location IDRequired
Discount Type
Discount (percentage or value, depending on type)
Tax
Is Tax InclusiveRequired
Receipt ReferenceRequired
Receipt AmountRequired
Receipt DateRequired
Account IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Description
Issue DateRequired
Due DateRequired
Vendor IDRequired
ReferenceRequired
Product id
Product SKU
Unit PriceRequired
QuantityRequired
Location IDRequired
Discount Type
Discount (percentage or value, depending on type)
Tax
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ReferenceRequired
NameRequired
description
Due on
Status
PrivateRequired
User
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ReferenceRequired
AmountRequired
DateRequired
Contact ID
KindRequired
Account IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Organization
Website
Phone Number
Primary Email
Tax Number
Secondary Phone Number
Secondary Email
Shipping Street
Shipping City
Shipping State
Shipping Zip
Shipping Country
Billing Street
Billing City
Billing State
Billing Zip
Billing Country
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product ID
Product SKU
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
Phone Number
Primary Email
Organization
Website
Tax Number
Secondary Phone Number
Secondary Email
Shipping Street
Shipping City
Shipping State
Shipping Zip
Shipping Country
Billing Street
Billing City
Billing State
Billing Zip
Billing Country
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSKURequired
Arabic NameRequired
English NameRequired
TaxRequired
Category
Unit
Description
Barcode
Tracked Product?Required
Purchasable?Required
Purchase Price
Purchase Account ID
Sellable?Required
Is Buying Price Tax Inclusive?
Selling Price
Sales Account ID
Is Selling Price Tax Inclusive?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier 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.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
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
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
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
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 Credit Note
Triggered when a new credit note is created
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Debit Note
Trigger when a new debit note is created
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Manual Journal Entry
Triggers when a Manual Journal Entry is created
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Project
Triggers when a new project is created
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Quotation
Triggers when a new quotation is created
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Stock Change
Lists all recently changed products
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Vendor
Triggers when a new vendor is created
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDescription
Issue dateRequired
Due DateRequired
Vendor IDRequired
ReferenceRequired
Product Id
Product SKU
Unit PriceRequired
QuantityRequired
Location IDRequired
Discount Type
Discount (percentage or value, depending on type)
Tax
Is Tax Inclusive?Required
Receipt ReferenceRequired
Receipt AmountRequired
Receipt DateRequired
Account IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Organization
Website
Phone Number
Primary Email
Tax Number
Secondary Phone Number
Secondary Email
Shipping Street
Shipping City
Shipping State
Shipping Zip
Shipping Country
Billing Street
Billing City
Billing State
Billing Zip
Billing Country
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Description
Issue dateRequired
Due DateRequired
Customer IdRequired
ReferenceRequired
Product ID
Product SKU
Unit PriceRequired
QuantityRequired
Location IDRequired
Discount Type
Discount (percentage or value, depending on type)
Tax
Is Tax Inclusive?Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DescriptionRequired
DateRequired
debitRequired
creditRequired
Comment
Account idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SKURequired
Arabic NameRequired
English NameRequired
TaxRequired
Category
Unit
Description
Barcode
Tracked Product?Required
Purchasable?Required
Purchase Price
Purchase Account ID
Sellable?Required
Is Buying Price Tax Inclusive?
Selling Price
Sales Account ID
Is Selling Price Tax Inclusive?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Description
Issue DateRequired
Due DateRequired
Customer IdRequired
ReferenceRequired
Product ID
Product SKU
Unit PriceRequired
QuantityRequired
Location IDRequired
Discount Type
Discount (percentage or value, depending on type)
Tax
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ReferenceRequired
NameRequired
Description
Due on
StatusRequired
PrivateRequired
Priority
User
Project
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer Name
Phone Number
email
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
Phone Number
Email
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct ID
SKURequired
Arabic NameRequired
English NameRequired
TaxRequired
Category
Unit
Description
Barcode
Tracked Product?Required
Purchasable?Required
Purchase Price
Purchase Account ID
Sellable?Required
Is Buying Price Tax Inclusive?
Selling Price
Sales Account ID
Is Selling Price Tax Inclusive?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNameRequired
Phone Number
Primary Email
Organization
Website
Tax Number
Secondary Phone Number
Secondary Email
Shipping Street
Shipping City
Shipping State
Shipping Zip
Shipping Country
Billing Street
Billing City
Billing State
Billing Zip
Billing Country
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo 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 ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
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
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
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
ColumnsRequired
Row CountRequired
First Row
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
About Google Sheets
Related categories
