edoobox + Google Sheets
Create Google Sheets rows for new edoobox bookings
For each new booking in edoobox, a row will be created in a Google Sheets spreadsheet. The Zapier template then checks whether the user already exists in the spreadsheet. If not, the user will be added to a Google Sheets row.
For each new booking in edoobox, a row will be created in a Google Sheets spreadsheet. The Zapier template then checks whether the user already exists in the spreadsheet. If not, the user will be added to a Google Sheets row.
- When this happens...
New Booking CreatedTriggers when a new booking is created.
TriggerInstantThis event starts a Zap instantly. - 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 Booking Created
Triggers when a new booking is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Booking Updated
Triggers when an existing booking is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Date (Polling)
Triggers when a new date is added. Using this option will not always give you all additional fields (e.g. Offer Name).
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Invoice (Polling)
Triggers when a new invoice is added. Using this option will not always give you all additional fields (e.g. Offer Name).
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Offer Created
Triggers when a new offer is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Offer Updated
Triggers when an existing offer is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Promotion (Polling)
Triggers when a new promotion is added. Using this option will not always give you all additional fields (e.g. Offer Name).
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew User (Polling)
Triggers when a new user is added. Using this option will not always give you all additional fields (e.g. Offer Name).
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNameRequired
Date StartRequired
Date EndRequired
Room ID
Offer IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
CampaignRequired
StartRequired
EndRequired
Booking maximumRequired
Total awardRequired
Minimum AmountRequired
CurrencyRequired
Code AliasRequired
OffsettingRequired
SettlementRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer ID (Owner)Required
ActionThis is an event a Zap performs.SearchFind existing data in your appInvoice IDRequired
Date Create (From)Required
Date Create (To)
ActionThis is an event a Zap performs.SearchFind existing data in your appPromotionRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCustomer IDRequired
Offer ID
Waiting ListRequired
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
Category IDRequired
Is MultiOffer
NumberRequired
TypeRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearchRequired
GenderRequired
First NameRequired
Last NameRequired
Status
Main Customer
Street
Postcode
Location
Country
Language Key
Phone Number
Email
Company
Additional Data 01
Additional Data 02
Additional Data 03
Additional Data 04
Additional Data 05
Additional Data 06
Additional Data 07
Additional Data 08
Additional Data 09
Additional Data 10
Additional Data 11
Additional Data 12
Additional Data 13
Additional Data 14
Additional Data 15
Additional Data 16
Additional Data 17
Additional Data 18
Additional Data 19
Additional Data 20
Additional Data 21
Additional Data 22
Additional Data 23
Additional Data 24
Additional Data 25
Additional Data 26
Additional Data 27
Additional Data 28
Additional Data 29
Additional Data 30
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 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 found
New Booking (Polling)
Triggers when a new booking is added. Using this option will not always give you all additional fields (e.g. Offer Name).
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Date Created
Triggers when a new date is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Invoice Created
Triggers when a new invoice is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Invoice Updated
Triggers when an existing invoice is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Offer (Polling)
Triggers when a new offer is added. Using this option will not always give you all additional fields (e.g. Offer Name).
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Promotion Created
Triggers when a new promotion is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New User Created
Triggers when a new user is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Customer IDRequired
Offer ID
Waiting ListRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Category IDRequired
Is MultiOffer
NameRequired
NumberRequired
TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.GenderRequired
First NameRequired
Last NameRequired
Status
Main Customer
Street
Postcode
Location
Country
Language Key
Phone Number
Email
Company
Additional Data 01
Additional Data 02
Additional Data 03
Additional Data 04
Additional Data 05
Additional Data 06
Additional Data 07
Additional Data 08
Additional Data 09
Additional Data 10
Additional Data 11
Additional Data 12
Additional Data 13
Additional Data 14
Additional Data 15
Additional Data 16
Additional Data 17
Additional Data 18
Additional Data 19
Additional Data 20
Additional Data 21
Additional Data 22
Additional Data 23
Additional Data 24
Additional Data 25
Additional Data 26
Additional Data 27
Additional Data 28
Additional Data 29
Additional Data 30
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearchRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
Date StartRequired
Date EndRequired
Room ID
Offer IDRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundPromotionRequired
NameRequired
CampaignRequired
StartRequired
EndRequired
Booking maximumRequired
Total awardRequired
Minimum AmountRequired
CurrencyRequired
Code AliasRequired
OffsettingRequired
SettlementRequired
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 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
About edoobox
Related categories
