ConditionalVisibility

new-products-promo

Customer stories

the-perk-online-ordering-autom primary img

Google Sheets

Mailchimp

Proof

SMS by Zapier

Squarespace

What do you do when the core of your business model unexpectedly changes? That's exactly the situation that The Perk, a coffee shop in Winter Park, Colorado, faced several weeks ago.

How a Colorado coffee shop powers online ordering with Zapier

This Zap automatically moves a new form submission from Squarespace into Google Sheets as a new row.

Squarespace is a website builder, blogging platform, hosting service, commerce platform, and domain name registrar.

Triggers when form submission is submitted.

New Form Submission

Custom Actions (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

API Request (Beta)

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.

New Spreadsheet Row (Team Drive)

Triggers when a new row is added to the bottom of a spreadsheet.

New Spreadsheet Row

Triggers when a new spreadsheet is created.

New Spreadsheet

Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.

New or Updated Spreadsheet Row (Team Drive)

Triggers when a new row is added or modified in a spreadsheet.

New or Updated Spreadsheet Row

Triggers when a worksheet is created in a spreadsheet.

New Worksheet

Find up to 500 rows based on a column and value as line items.

Lookup Spreadsheet Rows (Advanced)

Find Worksheet

Return up to 500 rows as a single JSON value or as line items.

Get Many Spreadsheet Rows (Advanced)

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Lookup Spreadsheet Row

Finds or creates a specific find worksheet.

Find or Create Worksheet

Find or Create Row

Create a new column in a specific spreadsheet.

Create Spreadsheet Column

Create a new row in a specific spreadsheet.

Create Spreadsheet Row

Create one or more new rows in a specific spreadsheet (with line item support).

Create Multiple Spreadsheet Rows

Creates a new worksheet by copying an existing worksheet.

Copy Worksheet

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Create Spreadsheet

Creates a new worksheet in a Google Sheet.

Create Worksheet

Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.

Clear Spreadsheet Row(s)

Deletes the selected row(s) from the spreadsheet. This action removes the row(s) and all associated data.

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row

Update one or more rows in a specific spreadsheet (with line item support).

Update Spreadsheet Row(s)

Create New Row in Google Sheets from New Squarespace Form Submission

You may have multiple team members editing a Google Sheets spreadsheet or automatically adding rows when, say, a new order comes in. To stay updated, use this Google Sheets SMS integration to send an SMS when a new row is added to a Google Sheets spreadsheet.

Using our built-in number, you can send a limited number of SMS / text messages. This is great for reminders!

Send an SMS to a number. Notice that a successful action means that the SMS has been queued, not delivered.

Send SMS

Send SMS messages for new Google Sheets rows

Adding customer emails to Mailchimp takes time. Use this integration to update your email lists with your customer information instantaneously. Once set up, Zapier will automatically create Mailchimp subscribers when you get new paid orders in Shopify. Your email lists will be complete letting you communicate with all of your customers.

Shopify is a simple way to create an online store to list products, collect credit card payments, and ship your goods.

Shopify

Triggers when a new blog is added to your Shopify store.

New Blog

Triggers when a new entry is added to a blog in your Shopify store.

New Blog Entry

Triggers when a new customer is added to your Shopify account.

New Customer

Triggers when a customer account is enabled.

Customer Account Enabled

Triggers when an Order Risk Level is medium, high or both.

New Fraudulent Order

Triggers whenever a cart is "abandoned" (only open carts) (with line item support).

New Abandoned Cart

Triggers whenever a order is "cancelled" (with line item support).

New Cancelled Order

Triggers whenever an order is cancelled (with line item support).

Triggers when a new draft order is created

New Draft Order

Triggers whenever a new purchase is "paid". You can choose a different order status like pending or refunded (with line item support).

New Paid Order

Triggers when an order is fulfilled (with line item support).

New Fulfilled Order

Triggers when a new purchase is made (only open orders) (with line item support).

New Order

Triggers when an order is created (with line item support).

Triggers when an order is paid (with line item support).

New Product

Triggers when a refund or partial refund occurs.

New Refund

Triggers when a new purchase is made (of any order status).

New Order (Any Status)

Triggers when a new product is added to your Shopify store.

Triggers when a new tag is added to a customer.

New Tag Added to Customer

Triggers when a customer's information is updated.

Updated Customer

Triggers when an Inventory Item quantity is updated.

Updated Inventory

Triggers when an order is updated (with line item support).

Updated Order

Triggers when a Product is updated, ordered or when a variant is added, removed, or updated.

Updated Product

Triggers when a tag has either been added or removed from an order.

Updated Tag in Order

Find Customer

Find Order

Gets all fulfillment orders for a given order ID.

Get Fulfillment Orders by Order ID

Get Order by ID

Searches for Metafields data for a given resource (example order Metafields).

Find Metafields

Finds the Transactions associated to an Order.

Find Order Transactions

Finds multiple Products by IDs. Returned as line items.

Find Products by ID (With Line Item Support)

Finds a list of products by searching the titles.

Find Products by Title (With Line Item Support)

Find Product by Title

Finds a product by handle. Titles can also be used if handles are not customized.

Find Product by Title or Handle

Finds a list of product variants by searching the titles.

Find Product Variants by Title (With Line Item Support)

Find Product Variant by SKU

Finds a product variant by a title search.

Find Product Variant by Title

Find or Create Customer

Finds or creates a specific product by title.

Find or Create Product

Finds or creates a specific product by title v2.

Finds or creates a specific product by title v3.

Finds or creates a specific product variant by title.

Find or Create Product Variant

Find or Create Product Variant V2

Add Line Item to Order

Add Tag to Customer

Create Blog Entry

Create Company

Create Product Variant

Create Customer

Creates a new draft order (with line item support).

Create Draft Order

Creates a fulfillment for one or many fulfillment orders that are associated with the same order and are assigned to the same location.

Create Fulfillment

Updates the quantity of an existing product variant.

Update Inventory Quantity

Updates the quantity of existing product variants.

Update Inventory Quantity (with line item support).

Creates a new order (with line item support).

Create Order

Create Product

Publishes a product to a channel (e.g., a sales channel).

Publish Product

Removes one or more tags from a customer.

Remove Tag from Customer

Create Transaction

Updates an existing customer. Replaces only data that is set.

Update Customer

Update Order

Updates an existing product. Replaces only data that is set.

Update Product

Updates an existing product variant. Replaces only data that is set.

Update Product Variant

Share your ideas with Mailchimp email newsletters—then use its landing page and form builders to grow your lists and take marketing further with drip and transactional emails.

How a Colorado coffee shop powers online ordering with Zapier

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.