Google Sheets + Skhokho
Create Skhokho invoices from new Google Sheets rows
This automation allows for the creation of invoices in Skhokho when new Google Sheets rows are added. The automation has two action steps:
This automation allows for the creation of invoices in Skhokho when new Google Sheets rows are added. The automation has two action steps:
- 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 InvoiceCreate a new invoice on Skhokho with data provided.
ActionWriteCreate a new record or update an existing record in your app. - then do this!Create Invoice Items
This action can be used to create line items for your invoice object. First you need to create a new invoice and obtain the uniqueId from the response. Then use the uniqueId to add line items to the that invoice.
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
New Account
Triggers when a new account is added on Skhokho.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Contact
Triggers when a new contact is added on Skhokho.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Hustle
Triggers when a new hustle is added on Skhokho.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Product
Triggers when a new product has been added on the Skhokho website for the authenticated user.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Quote
Triggers when a new quote is added on Skhokho.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planName Of The AccountRequired
Account DescriptionRequired
Select The Account Type
Opening Balance
Active
Allow Booking
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact First NameRequired
Contact Last NameRequired
Contact Phone NumberRequired
Contact Email AddressRequired
Contact Website
Contact Job Title
Company Name
Contact Twitter URL
Contact Facebook URL
Contact LinkedIn URL
Contact Instagram URL
Address Line 1
City
State/Province
Country
Postal Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Title Of The HustleRequired
Source of the Hustle
Company Name / Name Of OrganisationRequired
Company Email AddressRequired
Phone Number
Status Of The Hustle
Description
Financial Value Of Hustle
Hustle Budget
Spend
Priority Of The Hustle
Website URL
Company Size
Company Industry
Address Line 1
City
State/Province
Country
Postal Code
Twitter URL
Facebook URL
LinkedIn URL
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Unique Id of the InvoiceRequired
Title Of Line ItemRequired
Price Of Line ItemRequired
Quantity Of Line ItemsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project TitleRequired
Project Description
Project Scope of Work
Project Deliverables
Start Date of ProjectRequired
End Date of the ProjectRequired
Client Company NameRequired
Client Company EmailRequired
Company Phone
Company Tax Number
Company Website
Company Size
Company Industry
Address Line 1
City
State / Province
Country
Postal Code
Twitter
Facebook
Linked In
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Unique Id of the QuoteRequired
Item TitleRequired
Item PriceRequired
Item QuantityRequired
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 foundNew Client
Triggers when a new client has been added on Skhokho website.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Expense
Triggers when a new expense is added on Skhokho.
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 added on Skhokho.
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 has been added on the Skhokho website for the authenticated user.
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 added on Skhokho.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planCompany NameRequired
Company EmailRequired
Company PhoneRequired
Company Tax Number
Company Website
Company Size
Company Industry
Address Line 1
City
State/Province
Country
Postal Code
Twitter
Facebook
LinkedIn
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Title Of The ItemRequired
Item PriceRequired
QuantityRequired
Total
Recurring Monthly
Recurring Date
Status
Paid
Company NameRequired
Company Email AddresRequired
Phone Number
Tax Number
Address Line 1
City
State/Province
Country
Postal Code
Account TitleRequired
Account DescriptionRequired
Account CategoryRequired
Account Opening Balance
Account Active
Allow Time Booking
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Title of InvoiceRequired
Full Description
Additional Notes
Invoice Status
Tax Percentage
Recurring Monthly
Day Of The Month To Mail Invoice
Invoice Due Date
Company NameRequired
Company Email
Company Phone
Company Tax Number
Company Website
Company Size
Company Industry
Address Line 1
City
State/Province
Country
Postal Code
Twitter URL
Facebook URL
LinkedIn URL
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product TitleRequired
Product PriceRequired
Product / Service Description
Is this Product or Service
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Title of the Quote
Full Description
Additional Notes
Status
Tax Percentage
Company NameRequired
Company EmailRequired
Company Phone
Company Tax Number
Company Website
Company Size
Company Industry
Address Line 1
City
State/Province
Country
Postal Code
Twitter
Facebook
LinkedIn
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company Name / Name Of OrganisationRequired
Company Email AddressRequired
Phone Number
Tax Number
Address Line 1
City
State/Province
Country
Postal Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
About Google Sheets
Related categories
