Google Sheets + idloom
Create a new row at the top of Google Sheets for every idloom receipt received
This workflow allows you to seamlessly manage your financial data. When a new receipt is issued in idloom, it instantly creates a new row at the top of your selected Google Sheets spreadsheet. This automation both saves you the time of manual data entry and ensures immediate and accurate updates for seamless record keeping. Perfect for keeping your financial records up-to-date and organized.
This workflow allows you to seamlessly manage your financial data. When a new receipt is issued in idloom, it instantly creates a new row at the top of your selected Google Sheets spreadsheet. This automation both saves you the time of manual data entry and ensures immediate and accurate updates for seamless record keeping. Perfect for keeping your financial records up-to-date and organized.
- When this happens...
New ReceiptPolls your event or account regularly to find new receipts.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Spreadsheet Row at TopCreates a new spreadsheet row at the top of a spreadsheet (after the header row).
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Instant Event TriggerRequired
Allowed events
Custom manual action name
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Instant Event TriggerRequired
Allowed events
Custom manual action name
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Event UIDRequired
Last invoice number Retrieved
Invoice Number Prefix
Sort by
Sort order
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planAttendee's UIDRequired
Date from
Type of transaction
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planEvent uidRequired
Guest uidRequired
Type
Timestamp
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event uidRequired
Status
Event Name
Alias
Event URL
Organiser
Is Date Unknown?
Start Date
End Date
Is All Day Event?
has Registering period?
Registration start date
Registration end date
Enable "Notify Me" Feature?
Locale
location Type
Location name
Street name
Street Number
Box
Post code
City
State
Country
Latitude
Longitude
Timezone
Is Event Free?
Currency
is First steps inverted?
Skip step 2?
Skip step 3?
Skip step 4?
Display title on image?
Description
Display share?
Hide Event Address?
Map Zoom Level
Registration instructions
Tickets instructions
Hotels instructions
Check-out instructions
Show QR code on the confirmation page?
Display "Print your ticket" button on the confirmation page?
Display "Print summary" button on the confirmation page?
Display “Go to the Attendee Hub” button on the confirmation page?
Send confirmation email automatically?
Send confirmation email to accompanying person?
Be in BCC of automatic emails?
BCC email address
Override profile "Reply-to" email address
Display cover image in email?
Display full attendee's detail in email?
Display event location in email?
Display “Go to the Attendee Hub” button in email?
Include "Print Ticket" Button in Email?
Display QR code in email?
is Private?
is Domain redirection disabled?
Meta Title
Meta Description
Use specific content?
Social media Title
Social media Description
Attendee Hub & App Description
Force email uniqueness?
Activate captcha?
Allow attendees to resend themselves the confirmation email?
Allow attendees to modify their registration?
Allow ticket downgrades?
Allow attendees to cancel their registration?
Allow registrants to notify that they will not attend?
Activate restricted registration?
Pop-up text for restricted registration
Make the restricted code mandatory?
Use the same restricted code for all registrants?
Restricted code
Hide the event category?
Categories title
Activate stock management?
Sold-out label
Display remaining quantities when sold percentage reached
Hide sold-out items?
Activate waiting list for sold-out options?
Use global quantity for all categories?
Global quantity for all categories
Options title
Display filter by location for options?
Activate early bird prices for categories and/or options?
Allow registrants to select several of the same item?
Allow several consecutive registrations by the same attendee?
Activate specific dates for categories and options?
Create a QR code for categories and/or options?
Automatically generate invoice upon registration?
Generate and attach invoice to confirmation email?
Allow invoice updates?
Display generated invoices and credit notes on the Attendee Hub?
If invoicing address different from company address, display both on invoice?
Generate Belgian SEPA structured communication?
Activate CodaBox integration?
Attach receipt to confirmation email?
Display receipts in the Attendee Hub?
Activate Tax/VAT.?
Tax/VAT Label
Is Tax/VAT Included?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Attendee uid
event uidRequired
Updated After Date
Ignore Fields Mapping?
Sort by
Sort order
ActionThis is an event a Zap performs.SearchFind existing data in your appEvents Status
Event Language
Event UID
Sort by
Sort order
ActionThis is an event a Zap performs.SearchFind existing data in your appStatus
Event LanguageRequired
Event UID
Sort by
Sort order
Template event uid
Profile uidRequired
Apply Automatic Configuration?
Event NameRequired
Alias
Event URLRequired
Organiser
Is Date Unknown?
Start Date
End Date
Is All Day Event?
has Registering period?
Registration start date
Registration end date
Enable "Notify Me" Feature?
LocaleRequired
location TypeRequired
Location name
Street name
Street Number
Box
Post code
City
State
CountryRequired
Latitude
Longitude
TimezoneRequired
Is Event Free?
Currency
is First steps inverted?
Skip step 2?
Skip step 3?
Skip step 4?
Display title on image?
Description
Display share?
Hide Event Address?
Map Zoom Level
Registration instructions
Tickets instructions
Hotels instructions
Check-out instructions
Show QR code on the confirmation page?
Display "Print your ticket" button on the confirmation page?
Display "Print summary" button on the confirmation page?
Display “Go to the Attendee Hub” button on the confirmation page?
Send confirmation email automatically?
Send confirmation email to accompanying person?
Be in BCC of automatic emails?
BCC email address
Override profile "Reply-to" email address
Display cover image in email?
Display full attendee's detail in email?
Display event location in email?
Display “Go to the Attendee Hub” button in email?
Include "Print Ticket" Button in Email?
Display QR code in email?
is Private?
is Domain redirection disabled?
Meta Title
Meta Description
Use specific content?
Social media Title
Social media Description
Attendee Hub & App Description
Force email uniqueness?
Activate captcha?
Allow attendees to resend themselves the confirmation email?
Allow attendees to modify their registration?
Allow ticket downgrades?
Allow attendees to cancel their registration?
Allow registrants to notify that they will not attend?
Activate restricted registration?
Pop-up text for restricted registration
Make the restricted code mandatory?
Use the same restricted code for all registrants?
Restricted code
Hide the event category?
Categories title
Activate stock management?
Sold-out label
Display remaining quantities when sold percentage reached
Hide sold-out items?
Activate waiting list for sold-out options?
Use global quantity for all categories?
Global quantity for all categories
Options title
Display filter by location for options?
Activate early bird prices for categories and/or options?
Allow registrants to select several of the same item?
Allow several consecutive registrations by the same attendee?
Activate specific dates for categories and options?
Create a QR code for categories and/or options?
Automatically generate invoice upon registration?
Generate and attach invoice to confirmation email?
Allow invoice updates?
Display generated invoices and credit notes on the Attendee Hub?
If invoicing address different from company address, display both on invoice?
Generate Belgian SEPA structured communication?
Activate CodaBox integration?
Attach receipt to confirmation email?
Display receipts in the Attendee Hub?
Activate Tax/VAT.?
Tax/VAT Label
Is Tax/VAT Included?
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
Attendee uid
event uidRequired
Updated After Date
Ignore Fields Mapping?
Sort by
Sort order
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planEvent UIDRequired
Last invoice number Retrieved
Invoice Number Prefix
Sort by
Sort order
Show credit notes with negative amounts.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planEvents Status
Event Language
Event UID
Sort by
Sort order
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planEvent UIDRequired
Last invoice number Retrieved
Invoice Number Prefix
Sort by
Sort order
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New Profile
Polls your account regularly to find new profiles.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planInstant Event TriggerRequired
Allowed events
Custom manual action name
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Profile uidRequired
Event uidRequired
Anonymized At
Registration Status
LanguageRequired
Email AddressRequired
Title
First Name
Last Name
Phone Number
Mobile Phone Number
Confirmation Email Address
Has Accompanying Person?
Accompanying Person Title
Company Name
Job Title
Street Address
City
Postal code
Country
Check-ins
First check-in date
Paid by
Paying for
Comment
Notes
Hotel Notes
Coupon
Coupon Code
Coupon Discount
Category idRequired
Hotel
Total Price (taxes included)
Total Price (taxes excluded)
Amount of Taxes
Payment Status
Payment Method
Payment Date
Payment Amount
Last Invoice Number
Last Invoice Date
Last Invoice Due Date
Last proforma number
Last Proforma Date
Last Credit note number
Last credit Note Date
id
SKU
Name
Full Name
Location
Start Date
End Date
Available Quantity
Booked Quantity
Early Bird Booked Quantity
Total Booked Quantity
Is Sold Out?
Standard Price
Early Bird Price
Early Bird Deadline
Linked Option IDs
id
SKU
Name
Full Name
Description
Location
Start Date
End Date
Available Quantity
Booked Quantity
Early Bird Booked Quantity
Total Booked Quantity
Is Sold Out?
Standard Price
Early Bird Price
Early Bird Deadline
Linked Category ids
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Template event uid
Profile uidRequired
Event LanguageRequired
Apply Automatic Configuration?
Status
Event NameRequired
Alias
Event URLRequired
Organiser
Is Date Unknown?
Start Date
End Date
Is All Day Event?
has Registering period?
Registration start date
Registration end date
Enable "Notify Me" Feature?
LocaleRequired
location TypeRequired
Location name
Street name
Street Number
Box
Post code
City
State
CountryRequired
Latitude
Longitude
TimezoneRequired
Is Event Free?
Currency
is First steps inverted?
Skip step 2?
Skip step 3?
Skip step 4?
Display title on image?
Description
Display share?
Hide Event Address?
Map Zoom Level
Registration instructions
Tickets instructions
Hotels instructions
Check-out instructions
Show QR code on the confirmation page?
Display "Print your ticket" button on the confirmation page?
Display "Print summary" button on the confirmation page?
Display “Go to the Attendee Hub” button on the confirmation page?
Send confirmation email automatically?
Send confirmation email to accompanying person?
Be in BCC of automatic emails?
BCC email address
Override profile "Reply-to" email address
Display cover image in email?
Display full attendee's detail in email?
Display event location in email?
Display “Go to the Attendee Hub” button in email?
Include "Print Ticket" Button in Email?
Display QR code in email?
is Private?
is Domain redirection disabled?
Meta Title
Meta Description
Use specific content?
Social media Title
Social media Description
Attendee Hub & App Description
Force email uniqueness?
Activate captcha?
Allow attendees to resend themselves the confirmation email?
Allow attendees to modify their registration?
Allow ticket downgrades?
Allow attendees to cancel their registration?
Allow registrants to notify that they will not attend?
Activate restricted registration?
Pop-up text for restricted registration
Make the restricted code mandatory?
Use the same restricted code for all registrants?
Restricted code
Hide the event category?
Categories title
Activate stock management?
Sold-out label
Display remaining quantities when sold percentage reached
Hide sold-out items?
Activate waiting list for sold-out options?
Use global quantity for all categories?
Global quantity for all categories
Options title
Display filter by location for options?
Activate early bird prices for categories and/or options?
Allow registrants to select several of the same item?
Allow several consecutive registrations by the same attendee?
Activate specific dates for categories and options?
Create a QR code for categories and/or options?
Automatically generate invoice upon registration?
Generate and attach invoice to confirmation email?
Allow invoice updates?
Display generated invoices and credit notes on the Attendee Hub?
If invoicing address different from company address, display both on invoice?
Generate Belgian SEPA structured communication?
Activate CodaBox integration?
Attach receipt to confirmation email?
Display receipts in the Attendee Hub?
Activate Tax/VAT.?
Tax/VAT Label
Is Tax/VAT Included?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Guest uidRequired
Invoice uid
Payment dateRequired
Amount paidRequired
Payment reference
Payment method
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event uidRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appAttendee uid
Event uidRequired
Updated After Date
Ignore Fields Mapping?
Sort by
Sort order
Profile uidRequired
Anonymized At
Registration Status
LanguageRequired
Email AddressRequired
Title
First Name
Last Name
Phone Number
Mobile Phone Number
Confirmation Email Address
Has Accompanying Person?
Accompanying Person Title
Company Name
Job Title
Street Address
City
Postal code
Country
Check-ins
First check-in date
Paid by
Paying for
Comment
Notes
Hotel Notes
Coupon
Coupon Code
Coupon Discount
Category idRequired
Hotel
Total Price (taxes included)
Total Price (taxes excluded)
Amount of Taxes
Payment Status
Payment Method
Payment Date
Payment Amount
Last Invoice Number
Last Invoice Date
Last Invoice Due Date
Last proforma number
Last Proforma Date
Last Credit note number
Last credit Note Date
id
SKU
Name
Full Name
Location
Start Date
End Date
Available Quantity
Booked Quantity
Early Bird Booked Quantity
Total Booked Quantity
Is Sold Out?
Standard Price
Early Bird Price
Early Bird Deadline
Linked Option IDs
id
SKU
Name
Full Name
Description
Location
Start Date
End Date
Available Quantity
Booked Quantity
Early Bird Booked Quantity
Total Booked Quantity
Is Sold Out?
Standard Price
Early Bird Price
Early Bird Deadline
Linked Category ids
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 Google Sheets
Related categories
