Connect Shopify with Google Sheets
Unlock the superpowers of Shopify + Google Sheets and automate your tasks without having to write a single line of code.
Shopify and Google Sheets
your way
Check out the available triggers and actions in the automation of apps Shopify + Google Sheets
Created order
For each created order on ShopifyHow it works:
Whenever something happens on the source app
All happening in a single automation! ✨
Created order
For each created order on ShopifyTrigger
Order: ID
Order: Creation date/time
Order: Creation date/time (formatted YYYY-MM-DD H:M:S).
Order: Total amount (decimal)
Order: Total amount (formatted in reais)
Order: Subtotal amount (decimal)
Order: Subtotal amount (formatted in reais)
Order: Weight (g)
Order: Total fee (decimal)
Order: Currency
Order: Full discount (decimal)
Order: Total discount percentage (decimal)
Order: Total amount of items (decimal)
Request: Customer Location
Order number
Order: Discount codes (comma separated)
Order: Note
Order: Note attributes (comma separated)
Order: Name of note attributes (separated by comma)
Order: Amount of note attributes (separated by comma)
Order: Payment Gateway
Request: Payment gateway names (comma separated)
Order: Origin name
Order: Tags (comma separated)
Request: URL
Order: Full shipping (decimal)
Order: Total shipping (formatted in reais)
Order: Tips Total (decimal)
Order: Summary of items (Title - Quantity - Variation - SKU - Tags - Amount). Separated by comma.
Order: Summary of items (Title - Quantity - Amount). Separated by comma.
Order: Summary of items (Title - Amount). Separated by comma.
Order: Summary of items (Title - SKU). Separated by comma.
Order: Summary of items (Title - Quantity - Variation). Separated by comma.
Order: Name of items (Title). Separated by comma.
Order: Full name of items (Title + Variant). Separated by comma.
Order: Item quantities (Quantity). Separated by comma.
Order: Comma separated SKUs
Order: Shipping summary (Title - Amount). Separated by comma.
Billing: full name
Billing: first name
Billing: second name
Billing: telephone
Billing: city
Billing: state
Billing: country
Billing: Zip Code
Billing: Address
Billing: Supplement
Billing: company
Billing: country code
Billing: UF
Delivery: full name
Delivery: first name
Delivery: second name
Delivery: telephone
Delivery: city
Delivery: state
Delivery: country
Delivery: Zip Code
Delivery: Address
Delivery: Complement
Delivery: company
Delivery: country code
Delivery: UF
Customer: ID
Customer: Email
Customer: Do you acZip Codet email marketing?
Customer: Creation date/time
Customer: Update date/time
Customer: First name
Customer: Last name
Customer: Notes
Customer: Tax exempt?
Customer: Telephone
Customer: Tags (comma separated)
Customer: Currency
Customer (default address): First name
Customer (default address): Last name
Customer (default address): Company
Customer (default address): Address
Customer (default address): Complement
Customer (default address): City
Customer (default address): State
Customer (default address): Country
Customer (default address): Zip Code
Customer (default address): Telephone
Customer (default address): Full name
Customer (default address): UF
Customer (default address): Country code
Customer (default address): Country name
Order refunded
For each refunded order on ShopifyHow it works:
Whenever something happens on the source app
All happening in a single automation! ✨
Order refunded
For each refunded order on ShopifyTrigger
Order: ID
Order: Creation date/time
Order: Creation date/time (formatted YYYY-MM-DD H:M:S).
Order: Total amount (decimal)
Order: Total amount (formatted in reais)
Order: Subtotal amount (decimal)
Order: Subtotal amount (formatted in reais)
Order: Weight (g)
Order: Total fee (decimal)
Order: Currency
Order: Full discount (decimal)
Order: Total discount percentage (decimal)
Order: Total amount of items (decimal)
Request: Customer Location
Order number
Order: Discount codes (comma separated)
Order: Note
Order: Note attributes (comma separated)
Order: Name of note attributes (separated by comma)
Order: Amount of note attributes (separated by comma)
Order: Payment Gateway
Request: Payment gateway names (comma separated)
Order: Origin name
Order: Tags (comma separated)
Request: URL
Order: Full shipping (decimal)
Order: Total shipping (formatted in reais)
Order: Tips Total (decimal)
Order: Summary of items (Title - Quantity - Variation - SKU - Tags - Amount). Separated by comma.
Order: Summary of items (Title - Quantity - Amount). Separated by comma.
Order: Summary of items (Title - Amount). Separated by comma.
Order: Summary of items (Title - SKU). Separated by comma.
Order: Summary of items (Title - Quantity - Variation). Separated by comma.
Order: Name of items (Title). Separated by comma.
Order: Full name of items (Title + Variant). Separated by comma.
Order: Item quantities (Quantity). Separated by comma.
Order: Comma separated SKUs
Order: Shipping summary (Title - Amount). Separated by comma.
Billing: full name
Billing: first name
Billing: second name
Billing: telephone
Billing: city
Billing: state
Billing: country
Billing: Zip Code
Billing: Address
Billing: Supplement
Billing: company
Billing: country code
Billing: UF
Delivery: full name
Delivery: first name
Delivery: second name
Delivery: telephone
Delivery: city
Delivery: state
Delivery: country
Delivery: Zip Code
Delivery: Address
Delivery: Complement
Delivery: company
Delivery: country code
Delivery: UF
Customer: ID
Customer: Email
Customer: Do you acZip Codet email marketing?
Customer: Creation date/time
Customer: Update date/time
Customer: First name
Customer: Last name
Customer: Notes
Customer: Tax exempt?
Customer: Telephone
Customer: Tags (comma separated)
Customer: Currency
Customer (default address): First name
Customer (default address): Last name
Customer (default address): Company
Customer (default address): Address
Customer (default address): Complement
Customer (default address): City
Customer (default address): State
Customer (default address): Country
Customer (default address): Zip Code
Customer (default address): Telephone
Customer (default address): Full name
Customer (default address): UF
Customer (default address): Country code
Customer (default address): Country name
Request: Refund date/time
Request: Refund date/time (formatted YYYY-MM-DD H:M:S)
Request: Justification for refund
Order: Full refunded
Processed order
For each processed order on ShopifyHow it works:
Whenever something happens on the source app
All happening in a single automation! ✨
Processed order
For each processed order on ShopifyTrigger
Order: ID
Order: Creation date/time
Order: Creation date/time (formatted YYYY-MM-DD H:M:S).
Order: Total amount (decimal)
Order: Total amount (formatted in reais)
Order: Subtotal amount (decimal)
Order: Subtotal amount (formatted in reais)
Order: Weight (g)
Order: Total fee (decimal)
Order: Currency
Order: Full discount (decimal)
Order: Total discount percentage (decimal)
Order: Total amount of items (decimal)
Request: Customer Location
Order number
Order: Discount codes (comma separated)
Order: Note
Order: Note attributes (comma separated)
Order: Name of note attributes (separated by comma)
Order: Amount of note attributes (separated by comma)
Order: Payment Gateway
Request: Payment gateway names (comma separated)
Order: Origin name
Order: Tags (comma separated)
Request: URL
Order: Full shipping (decimal)
Order: Total shipping (formatted in reais)
Order: Tips Total (decimal)
Order: Summary of items (Title - Quantity - Variation - SKU - Tags - Amount). Separated by comma.
Order: Summary of items (Title - Quantity - Amount). Separated by comma.
Order: Summary of items (Title - Amount). Separated by comma.
Order: Summary of items (Title - SKU). Separated by comma.
Order: Summary of items (Title - Quantity - Variation). Separated by comma.
Order: Name of items (Title). Separated by comma.
Order: Full name of items (Title + Variant). Separated by comma.
Order: Item quantities (Quantity). Separated by comma.
Order: Comma separated SKUs
Order: Shipping summary (Title - Amount). Separated by comma.
Billing: full name
Billing: first name
Billing: second name
Billing: telephone
Billing: city
Billing: state
Billing: country
Billing: Zip Code
Billing: Address
Billing: Supplement
Billing: company
Billing: country code
Billing: UF
Delivery: full name
Delivery: first name
Delivery: second name
Delivery: telephone
Delivery: city
Delivery: State
Delivery: country
Delivery: Zip Code
Delivery: Address
Delivery: Complement
Delivery: company
Delivery: country code
Delivery: UF
Customer: ID
Customer: Email
Customer: Do you acZip Codet email marketing?
Customer: Creation date/time
Customer: Update date/time
Customer: First name
Customer: Last name
Customer: Notes
Customer: Tax exempt?
Customer: Telephone
Customer: Tags (comma separated)
Customer: Currency
Customer (default address): First name
Customer (default address): Last name
Customer (default address): Company
Customer (default address): Address
Customer (default address): Complement
Customer (default address): City
Customer (default address): State
Customer (default address): Country
Customer (default address): Zip Code
Customer (default address): Telephone
Customer (default address): Full name
Customer (default address): UF
Customer (default address): Country code
Customer (default address): Country name
Order reversed
For each nullified/refunded payment order on ShopifyHow it works:
Whenever something happens on the source app
All happening in a single automation! ✨
Order reversed
For each nullified/refunded payment order on ShopifyTrigger
Order: ID
Order: Creation date/time
Order: Creation date/time (formatted YYYY-MM-DD H:M:S).
Order: Total amount (decimal)
Order: Total amount (formatted in reais)
Order: Subtotal amount (decimal)
Order: Subtotal amount (formatted in reais)
Order: Weight (g)
Order: Total fee (decimal)
Order: Currency
Order: Full discount (decimal)
Order: Total discount percentage (decimal)
Order: Total amount of items (decimal)
Request: Customer Location
Order number
Order: Discount codes (comma separated)
Order: Note
Order: Note attributes (comma separated)
Order: Name of note attributes (separated by comma)
Order: Amount of note attributes (separated by comma)
Order: Payment Gateway
Request: Payment gateway names (comma separated)
Order: Origin name
Order: Tags (comma separated)
Request: URL
Order: Full shipping (decimal)
Order: Total shipping (formatted in reais)
Order: Tips Total (decimal)
Order: Summary of items (Title - Quantity - Variation - SKU - Tags - Amount). Separated by comma.
Order: Summary of items (Title - Quantity - Amount). Separated by comma.
Order: Summary of items (Title - Amount). Separated by comma.
Order: Summary of items (Title - SKU). Separated by comma.
Order: Summary of items (Title - Quantity - Variation). Separated by comma.
Order: Name of items (Title). Separated by comma.
Order: Full name of items (Title + Variant). Separated by comma.
Order: Item quantities (Quantity). Separated by comma.
Order: Comma separated SKUs
Order: Shipping summary (Title - Amount). Separated by comma.
Billing: full name
Billing: first name
Billing: second name
Billing: telephone
Billing: city
Billing: state
Billing: country
Billing: Zip Code
Billing: Address
Billing: Supplement
Billing: company
Billing: country code
Billing: UF
Delivery: full name
Delivery: first name
Delivery: second name
Delivery: telephone
Delivery: city
Delivery: state
Delivery: country
Delivery: Zip Code
Delivery: Address
Delivery: Complement
Delivery: company
Delivery: country code
Delivery: UF
Customer: ID
Customer: Email
Customer: Do you acZip Codet email marketing?
Customer: Creation date/time
Customer: Update date/time
Customer: First name
Customer: Last name
Customer: Notes
Customer: Tax exempt?
Customer: Telephone
Customer: Tags (comma separated)
Customer: Currency
Customer (default address): First name
Customer (default address): Last name
Customer (default address): Company
Customer (default address): Address
Customer (default address): Complement
Customer (default address): City
Customer (default address): State
Customer (default address): Country
Customer (default address): Zip Code
Customer (default address): Telephone
Customer (default address): Full name
Customer (default address): UF
Customer (default address): Country code
Customer (default address): Country name
Request: Refund date/time
Order: Refund date/time (formatted YYYY-MM-DD H:M:S)
Request: Justification for reversal
Paid order
For each paid order on ShopifyHow it works:
Whenever something happens on the source app
All happening in a single automation! ✨
Paid order
For each paid order on ShopifyTrigger
Order: ID
Order: Creation date/time
Order: Creation date/time (formatted YYYY-MM-DD H:M:S).
Order: Total amount (decimal)
Order: Total amount (formatted in reais)
Order: Subtotal amount (decimal)
Order: Subtotal amount (formatted in reais)
Order: Weight (g)
Order: Total fee (decimal)
Order: Currency
Order: Full discount (decimal)
Order: Total discount percentage (decimal)
Order: Total amount of items (decimal)
Request: Customer Location
Order number
Order: Discount codes (comma separated)
Order: Note
Order: Note attributes (comma separated)
Order: Name of note attributes (separated by comma)
Order: Amount of note attributes (separated by comma)
Order: Payment Gateway
Request: Payment gateway names (comma separated)
Order: Origin name
Order: Tags (comma separated)
Request: URL
Order: Full shipping (decimal)
Order: Total shipping (formatted in reais)
Order: Tips Total (decimal)
Order: Summary of items (Title - Quantity - Variation - SKU - Tags - Amount). Separated by comma.
Order: Summary of items (Title - Quantity - Amount). Separated by comma.
Order: Summary of items (Title - Amount). Separated by comma.
Order: Summary of items (Title - SKU). Separated by comma.
Order: Summary of items (Title - Quantity - Variation). Separated by comma.
Order: Name of items (Title). Separated by comma.
Order: Full name of items (Title + Variant). Separated by comma.
Order: Item quantities (Quantity). Separated by comma.
Order: Comma separated SKUs
Order: Shipping summary (Title - Amount). Separated by comma.
Billing: full name
Billing: first name
Billing: second name
Billing: telephone
Billing: city
Billing: state
Billing: country
Billing: Zip Code
Billing: Address
Billing: Supplement
Billing: company
Billing: country code
Billing: UF
Delivery: full name
Delivery: first name
Delivery: second name
Delivery: telephone
Delivery: city
Delivery: state
Delivery: country
Delivery: Zip Code
Delivery: Address
Delivery: Complement
Delivery: company
Delivery: country code
Delivery: UF
Customer: ID
Customer: Email
Customer: Do you acZip Codet email marketing?
Customer: Creation date/time
Customer: Update date/time
Customer: First name
Customer: Last name
Customer: Notes
Customer: Tax exempt?
Customer: Telephone
Customer: Tags (comma separated)
Customer: Currency
Customer (default address): First name
Customer (default address): Last name
Customer (default address): Company
Customer (default address): Address
Customer (default address): Complement
Customer (default address): City
Customer (default address): State
Customer (default address): Country
Customer (default address): Zip Code
Customer (default address): Telephone
Customer (default address): Full name
Customer (default address): UF
Customer (default address): Country code
Customer (default address): Country name
Order: Payment date/time
Order: Payment date/time (formatted YYYY-MM-DD H:M:S)
New added row
When a new row is added on Google SheetsHow it works:
Whenever something happens on the source app
All happening in a single automation! ✨
New added row
When a new row is added on Google SheetsTrigger
Line No.
Insert row in spreadsheet
add data to a new row on a Google Sheets spreadsheetHow it works:
Whenever something happens on the source app
1.
All happening in a single automation! ✨
Insert row in spreadsheet
add data to a new row on a Google Sheets spreadsheetAction
Columns
Update/insert row in spreadsheet
update or add data in Google Sheets spreadsheet's row(s)How it works:
Whenever something happens on the source app
1.
All happening in a single automation! ✨
Update/insert row in spreadsheet
update or add data in Google Sheets spreadsheet's row(s)Action
Didn't find your use case? Send suggestion.
Automate Shopify and Google Sheets with Pluga integrations
Explore automation templates
For each refunded order on Shopify, add data to a new row on a Google Sheets spreadsheet
EXPLORE For each created order on Shopify, add data to a new row on a Google Sheets spreadsheet
EXPLORE For each paid order on Shopify, add data to a new row on a Google Sheets spreadsheet
EXPLORE For each processed order on Shopify, add data to a new row on a Google Sheets spreadsheet
EXPLORE For each nullified/refunded payment order on Shopify, add data to a new row on a Google Sheets spreadsheet
EXPLORE For each refunded order on Shopify, update or add data in a new row of a Google Sheets spreadsheet
EXPLORE For each created order on Shopify, update or add data in a new row of a Google Sheets spreadsheet
EXPLORE For each paid order on Shopify, update or add data in a new row of a Google Sheets spreadsheet
EXPLORE For each processed order on Shopify, update or add data in a new row of a Google Sheets spreadsheet
EXPLORE For each nullified/refunded payment order on Shopify, update or add data in a new row of a Google Sheets spreadsheet
EXPLORE Miss an automation with this apps?
Say to us!Trusted by over 10.000 amazing companies
How to integrate apps with Pluga?
Pluga allows you to integrate two or more apps in a simple, practical way without needing to type a single line of code. Here are the steps to automate your tasks and start focusing on what really matters.
-
What is the automation trigger?
The trigger is the step that initiates automation. In the integration process, it is selected after choosing the source app. For example, if you choose Facebook Lead Ads as the source app, the trigger could be: For each response on an advertisement.
-
What is an action within an automation?
The action serves as a response to the previously selected trigger. That is, it occurs once the trigger is activated. For example, in an automation between Facebook Lead Ads (source) and Google Sheets (destination), as soon as the trigger “For each response on an advertisement” is activated in the source app, the action “Add data to a new row on a spreadsheet” will be carried out in the destination app.
-
How does information mapping work?
Information mapping is where you configure which captured information from the source app will be sent to each field in the destination app(s).
For example, in an automation between Facebook Lead Ads and Google Sheets, this step is where you will determine which contact information should fill in the spreadsheet fields.
-
Is it possible to have more than one action?
With Pluga, you can create automations by integrating several apps at once. For example, you can integrate Facebook Lead Ads + Google Sheets + Slack, so when the trigger is activated, the first action is executed and a notification is sent via Slack.
Automate Shopify + Google Sheets
and say goodbye to manual (and tedious) tasks!
By connecting the apps you use through Pluga, you can automate various processes in your routine and have time for tasks that really matter. 
Shopify
EcommerceShopify is one of the world's largest e-commerce platforms. With it, you can create and manage online stores, process payments, manage inventory, analyze sales, and expand your business.
Integrations with Shopify Visit Shopify Google Sheets
SpreadsheetGoogle Sheets is Google's online spreadsheet app that allows users to create, edit, share, and collaborate on documents both synchronously and asynchronously. It's a versatile tool for any type and size of business, serving purposes from CRM to inventory management spreadsheets.
Integrations with Google Sheets Visit Google Sheets