Google Sheets + Qoyod
Create purchase orders in Qoyod from new rows in Google Sheets
Seamlessly handle your purchasing process with this streamlined workflow. When you add a new row in Google Sheets, it initiates the creation of a purchase order in Qoyod. This automation ensures your financial records are consistently updated, making managing finances easier and more efficient.
Seamlessly handle your purchasing process with this streamlined workflow. When you add a new row in Google Sheets, it initiates the creation of a purchase order in Qoyod. This automation ensures your financial records are consistently updated, making managing finances easier and more efficient.
- 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 Purchase OrderCreates a purchase order
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.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.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
New Bill
Triggers when a bill is created
Try ItTriggerThis is the start of your ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier checks for new data every 15 min on the Free planNew Product
New Product is created
Try ItTriggerThis is the start of your ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 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 found
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
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.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Apply standard error handling?Required
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
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 foundNew Credit Note
Triggered when a new credit note is created
Try ItTriggerThis is the start of your ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 found
About Google Sheets
Related categories
About Qoyod
Related categories
Related Zap Templates
- Create invoices in Qoyod from new rows in Google Sheets
- Create new Qoyod bills from new Google Sheets spreadsheet rows
- Create new rows in Google Sheets for new invoices in Qoyod
- Create manual journal entries in Qoyod from new rows in Google Sheets
- Update spreadsheet rows in Google Sheets with new invoices from Qoyod