Google Sheets + Qoyod

Create manual journal entries in Qoyod from new rows in Google Sheets

Keep your accounting updated efficiently every time there is a new entry in your Google Sheets. Whenever a new row appears in your spreadsheet, this workflow will create a manual journal entry in Qoyod instantly. It not only allows for quicker data transfer but also ensures error-free entries, keeping your business financials always in order. Perfect for those looking to streamline their bookkeeping processes without manual intervention.

When this happens...
TriggerScheduled
automatically do this!
Create Manual Journal Entry
Create a Manual Journal Entry
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

New Bill
Triggers when a bill is created
Trigger
Scheduled
Try It
New Customer
Triggers when a new customer is created
Trigger
Scheduled
Try It
New Invoice
triggers when a new invoice is created
Trigger
Scheduled
Try It
New Product
New Product is created
Trigger
Scheduled
Try It
New Purchase Order
Triggers when a new Purchase Order is created
Trigger
Scheduled
Try It

New Receipt
Triggers when a receipt is created
Trigger
Scheduled
Try It
New Task
Triggers when a new task is created
Trigger
Scheduled
Try It

- 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
Action
Write
- 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
Action
Write
- 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
Action
Write
- 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
Action
Write
- 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
Action
Write
- ReferenceRequired
- NameRequired
- description
- Due on
- Status
- PrivateRequired
- User
Action
Write
- ReferenceRequired
- AmountRequired
- DateRequired
- Contact ID
- KindRequired
- Account IDRequired
Action
Write
- 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
Action
Write
- Product ID
- Product SKU
Action
Search
- NameRequired
- 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
Action
Search or write
- 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?
Action
Search or write

New Credit Note
Triggered when a new credit note is created
Trigger
Scheduled
Try It
New Debit Note
Trigger when a new debit note is created
Trigger
Scheduled
Try It
New Manual Journal Entry
Triggers when a Manual Journal Entry is created
Trigger
Scheduled
Try It
New Project
Triggers when a new project is created
Trigger
Scheduled
Try It
New Quotation
Triggers when a new quotation is created
Trigger
Scheduled
Try It
New Stock Change
Lists all recently changed products
Trigger
Scheduled
Try It
New Vendor
Triggers when a new vendor is created
Trigger
Scheduled
Try It
- 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
- Receipt ReferenceRequired
- Receipt AmountRequired
- Receipt DateRequired
- Account IDRequired
Action
Write
- 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
Action
Write
- 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
Action
Write
- DescriptionRequired
- DateRequired
- debitRequired
- creditRequired
- Comment
- Account idRequired
Action
Write
- 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?
Action
Write
- 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
Action
Write
- ReferenceRequired
- NameRequired
- Description
- Due on
- StatusRequired
- PrivateRequired
- Priority
- User
- Project
Action
Write
- Customer Name
- Phone Number
- email
Action
Search
- NameRequired
- Phone Number
- Email
Action
Search
- Product 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?
Action
Search or write
- NameRequired
- 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
Action
Search or write