Lemon Squeezy
Append Lemon Squeezy customer rows to Google Sheets
This query returns Lemon Squeezy customer records matching the given email address (exact match).
Developer info
- API endpoint slug
- lemon_squeezy.search_customers_by_email
- Runtime method
- performQuery("lemon_squeezy.search_customers_by_email"}
Query fields
Email Text input > Other
- Label
- Email address
- Helper text
- The customer's email address. Lemon Squeezy matches the address exactly — partial / fuzzy matches aren't supported.
- Slug
- Required
- true
- Can have default value
- true
Ingredients
Customer
- Slug
- customer_id
- Filter code
- LemonSqueezy.searchCustomersByEmail.CustomerId
- Type
- String
- Example
- 5678
Customer name
- Slug
- customer_name
- Filter code
- LemonSqueezy.searchCustomersByEmail.CustomerName
- Type
- String
- Example
- Jane Doe
Customer email
- Slug
- customer_email
- Filter code
- LemonSqueezy.searchCustomersByEmail.CustomerEmail
- Type
- String
- Example
- jane@example.com
Status Email-marketing status: subscribed, unsubscribed, archived, requires_verification, invalid_email.
- Slug
- status
- Filter code
- LemonSqueezy.searchCustomersByEmail.Status
- Type
- String
- Example
- subscribed
Total revenue Lifetime revenue from this customer, formatted with currency symbol.
- Slug
- total_revenue
- Filter code
- LemonSqueezy.searchCustomersByEmail.TotalRevenue
- Type
- String
- Example
- $129.87
Customer portal url Signed URL to the customer's self-serve portal.
- Slug
- customer_portal_url
- Filter code
- LemonSqueezy.searchCustomersByEmail.CustomerPortalUrl
- Type
- String
- Example
- https://app.lemonsqueezy.com/billing?signed=…
Created at
- Slug
- created_at
- Filter code
- LemonSqueezy.searchCustomersByEmail.CreatedAt
- Type
- Date with time (ISO8601)
- Example
- 2020-07-08T04:17:06+05:00
