Connect Google Sheets with Loja Integrada

Unlock the superpowers of Google Sheets + Loja Integrada and automate your tasks without having to write a single line of code.

Or explore automation templates

Automate Google Sheets and Loja Integrada
with Pluga integrations

Google Sheets and Loja Integrada
your way

Check out the available triggers and actions in the automation of apps Google Sheets + Loja Integrada

Trigger
Google Sheets

New added row

When a new row is added on Google Sheets

Line No.

Trigger
Loja Integrada

Cancelled order

For each cancelled order on Loja Integrada

Order items

ID (order number)

Code Status

Discount

Discount coupon code

Shipping

Subtotal Amount

Total Amount

Total Amount in Reais (text)

Modification date/time

Date/Time in format (DD/MM/YYYY - H:M:S)

Date modified in format (DD/MM/YYYY)

Modification time in format (H:M:S)

Date/Time Created

Date/Time in format (DD/MM/YYYY - H:M:S)

Creation date in format (DD/MM/YYYY)

Creation time in format (H:M:S)

Expiration Date/Time

Date/Time in format (DD/MM/YYYY - H:M:S)

Expiration date in format (DD/MM/YYYY)

Expiration time in format (H:M:S)

Customer ID

Customer Note

Payment Method Names

Item names

Item names and quantities

Item SKU

SKU and item quantities

Name, SKU and quantities of items

Item quantities

Subtotal of items

Quantidade total de itens no pedido

Customer Email

Customer name

Name: customer's first name

Name: customer's middle names (if any)

Name: customer's last name

Customer CPF

Customer CNPJ

Customer's Corporate Name

Customer's date of birth

Customer's Gender

Customer's cell phone

Customer's main telephone number

Delivery address

Delivery address complement

Delivery City

Delivery State

Delivery Country

Delivery Zip Code

Delivery number

Delivery District

Delivery Person Type

Delivery CPF

Delivery CNPJ

Delivery Reference

State Delivery Registration

Company name of the delivery address

Shipping method code

Shipping method name

Delivery tracking code (item)

Number of installments

UTM Campaign

Trigger
Loja Integrada

Order pending payment

When an order is waiting for payment on Loja Integrada.

Order items

ID

Code Status

Discount

Discount coupon code

Shipping

Subtotal Amount

Total Amount

Total Amount in Reais (text)

Modification date/time

Date/Time in format (DD/MM/YYYY - H:M:S)

Date modified in format (DD/MM/YYYY)

Modification time in format (H:M:S)

Date/Time Created

Date/Time in format (DD/MM/YYYY - H:M:S)

Creation date in format (DD/MM/YYYY)

Creation time in format (H:M:S)

Expiration Date/Time

Date/Time in format (DD/MM/YYYY - H:M:S)

Expiration date in format (DD/MM/YYYY)

Expiration time in format (H:M:S)

Customer ID

Customer Note

Payment Method Names

Item names

Item names and quantities

Item SKU

SKU and item quantities

Name, SKU and quantities of items

Item quantities

Subtotal of items

Quantidade total de itens no pedido

Customer Email

Customer name

Name: customer's first name

Name: customer's middle names (if any)

Name: customer's last name

Customer CPF

Customer CNPJ

Customer's Corporate Name

Customer's date of birth

Customer's Gender

Customer's cell phone

Customer's main telephone number

Delivery address

Delivery address complement

Delivery City

Delivery State

Delivery Country

Delivery Zip Code

Delivery number

Delivery District

Delivery Person Type

Delivery CPF

Delivery CNPJ

Delivery Reference

State Delivery Registration

Company name of the delivery address

Shipping method code

Shipping method name

Delivery tracking code (item)

Number of installments

UTM Campaign

Trigger
Google Sheets

For each row created/updated

For each row created or updated in Google Sheets

Nº da linha

Trigger
Loja Integrada

Paid order

For each order paid on Loja Integrada.

Order items

ID (order number)

Code Status

Discount

Discount coupon code

Shipping

Subtotal Amount

Total Amount

Total Amount in Reais (text)

Modification date/time

Date/Time of modification in format (DD/MM/YYYY - H:M:S)

Date modified in format (DD/MM/YYYY)

Modification time in format (H:M:S)

Date/Time Created

Date/Time in format (DD/MM/YYYY - H:M:S)

Creation date in format (DD/MM/YYYY)

Creation time in format (H:M:S)

Expiration Date/Time

Date/Time in format (DD/MM/YYYY - H:M:S)

Expiration date in format (DD/MM/YYYY)

Expiration time in format (H:M:S)

Customer ID

Customer Note

Payment Method Names

Item names

Item names and quantities

Item SKU

SKU and item quantities

Name, SKU and quantities of items

Item quantities

Subtotal of items

Quantidade total de itens no pedido

Customer Email

Customer name

Name: customer's first name

Name: customer's middle names (if any)

Name: customer's last name

Customer CPF

Customer CNPJ

Customer's Corporate Name

Customer's date of birth

Customer's Gender

Customer's cell phone

Customer's main telephone number

Delivery address

Delivery address complement

Delivery City

Delivery State

Delivery Country

Delivery Zip Code

Delivery number

Delivery District

Delivery Person Type

Delivery CPF

Delivery CNPJ

Delivery Reference

State Delivery Registration

Company name of the delivery address

Shipping method code

Shipping method name

Delivery tracking code (item)

Number of installments

UTM Campaign

Trigger
Loja Integrada

Delivered order

When an order is delivered on Loja Integrada

Order items

ID

Code Status

Discount

Discount coupon code

Shipping

Subtotal Amount

Total Amount

Total Amount in Reais (text)

Modification date/time

Date/Time in format (DD/MM/YYYY - H:M:S)

Date modified in format (DD/MM/YYYY)

Modification time in format (H:M:S)

Date/Time Created

Date/Time in format (DD/MM/YYYY - H:M:S)

Creation date in format (DD/MM/YYYY)

Creation time in format (H:M:S)

Expiration Date/Time

Date/Time in format (DD/MM/YYYY - H:M:S)

Expiration date in format (DD/MM/YYYY)

Expiration time in format (H:M:S)

Customer ID

Customer Note

Payment Method Names

Item names

Item names and quantities

Item SKU

SKU and item quantities

Name, SKU and quantities of items

Item quantities

Subtotal of items

Quantidade total de itens no pedido

Customer Email

Customer name

Name: customer's first name

Name: customer's middle names (if any)

Name: customer's last name

Customer CPF

Customer CNPJ

Customer's Corporate Name

Customer's date of birth

Customer's Gender

Customer's cell phone

Customer's main telephone number

Delivery address

Delivery address complement

Delivery City

Delivery State

Delivery Country

Delivery Zip Code

Delivery number

Delivery District

Delivery Person Type

Delivery CPF

Delivery CNPJ

Delivery Reference

State Delivery Registration

Company name of the delivery address

Shipping method code

Shipping method name

Delivery tracking code (item)

Number of installments

UTM Campaign

Trigger
Loja Integrada

Created order

For each created order on Loja Integrada

Order items

ID

Code Status

Discount

Discount coupon code

Shipping

Subtotal Amount

Total Amount

Total Amount in Reais (text)

Modification date/time

Date/Time in format (DD/MM/YYYY - H:M:S)

Date modified in format (DD/MM/YYYY)

Modification time in format (H:M:S)

Date/Time Created

Date/Time in format (DD/MM/YYYY - H:M:S)

Creation date in format (DD/MM/YYYY)

Creation time in format (H:M:S)

Expiration Date/Time

Date/Time in format (DD/MM/YYYY - H:M:S)

Expiration date in format (DD/MM/YYYY)

Expiration time in format (H:M:S)

Customer ID

Customer Note

Payment Method Names

Item names

Item names and quantities

Item SKU

SKU and item quantities

Name, SKU and quantities of items

Item quantities

Subtotal of items

Quantidade total de itens no pedido

Customer Email

Customer name

Name: customer's first name

Name: customer's middle names (if any)

Name: customer's last name

Customer CPF

Customer CNPJ

Customer's Corporate Name

Customer's date of birth

Customer's Gender

Customer's cell phone

Customer's main telephone number

Delivery address

Delivery address complement

Delivery City

Delivery State

Delivery Country

Delivery Zip Code

Delivery number

Delivery District

Delivery Person Type

Delivery CPF

Delivery CNPJ

Delivery Reference

State Delivery Registration

Company name of the delivery address

Shipping method code

Shipping method name

Delivery tracking code (item)

Number of installments

UTM Campaign

Trigger
Loja Integrada

Refunded payment

When an order is returned on Loja Integrada.

Order items

ID

Code Status

Discount

Discount coupon code

Shipping

Subtotal Amount

Total Amount

Total Amount in Reais (text)

Modification date/time

Date/Time in format (DD/MM/YYYY - H:M:S)

Date modified in format (DD/MM/YYYY)

Modification time in format (H:M:S)

Date/Time Created

Date/Time in format (DD/MM/YYYY - H:M:S)

Creation date in format (DD/MM/YYYY)

Creation time in format (H:M:S)

Expiration Date/Time

Date/Time in format (DD/MM/YYYY - H:M:S)

Expiration date in format (DD/MM/YYYY)

Expiration time in format (H:M:S)

Customer ID

Customer Note

Payment Method Names

Item names

Item names and quantities

Item SKU

SKU and item quantities

Name, SKU and quantities of items

Item quantities

Subtotal of items

Quantidade total de itens no pedido

Customer Email

Customer name

Name: customer's first name

Name: customer's middle names (if any)

Name: customer's last name

Customer CPF

Customer CNPJ

Customer's Corporate Name

Customer's date of birth

Customer's Gender

Customer's cell phone

Customer's main telephone number

Delivery address

Delivery address complement

Delivery City

Delivery State

Delivery Country

Delivery Zip Code

Delivery number

Delivery District

Delivery Person Type

Delivery CPF

Delivery CNPJ

Delivery Reference

State Delivery Registration

Company name of the delivery address

Shipping method code

Shipping method name

Delivery tracking code (item)

Number of installments

UTM Campaign

Trigger
Loja Integrada

Sent order

When an order is sent on Loja Integrada

Order items

Order: ID

Order: Code situation

Order: Discount

Order: Discount coupon code

Order: Freight

Order: Subtotal Amount

Order: Total amount

Order: Total amount in Reais (text)

Order: Date/Time

Order: Alteration Date/Time in format (DD/MM/YYYY - H:M:S)

Order: Alteration date in format (DD/MM/YYYY)

Order: Alteration hour in format (H:M:S)

Order: Creation Date/Hour

Order: Creation Date/Hour in format (DD/MM/YYYY - H:M:S)

Order: Creation date in format (DD/MM/YYYY)

Order: Creation hour in format (H:M:S)

Order: Expiration Date/Hour

Order: Expiration Date/Hour in format (DD/MM/YYYY - H:M:S)

Order: Expiration Date in format (DD/MM/YYYY)

Order: Expiration Hour in format (H:M:S)

Client: ID

Client: Obs

Order: Payment method names

Order: Itens names

Order: Item names and quantities

Order: Itens SKUs

Order: SKU and item quantities

Order: Name, SKU and quantities of items

Order: Itens quantities

Order: Itens subtotal

Quantidade total de itens no pedido

Client: Email

Client: Full name

Client: First name

Client: Middle names

Client: Last name

Client: CPF

Client: CNPJ

Client: Corporate name

Client: Birth date

Client: Gender

Client: Mobile phone number

Client: Telephone

Client: Delivery address

Client: Address complement

Client: City

Client: State

Client: Country

Client: Zip code

Client: Delivery number

Client: Neighborhood

Client: Delivery person type

Client: CPF

Client: CNPJ

Client: Delivery Reference

Client: State registration

Client: Corporate name

Order: Shipping method code

Order: Shipping method name

Delivery tracking code (item)

Order: Number of installments

Order: UTM Campaign

Action
Google Sheets

Insert row in spreadsheet

add data to a new row on a Google Sheets spreadsheet

Columns

Action
Google Sheets

Insert/update row in spreadsheet

add or update data in Google Sheets spreadsheet's row(s)

Action
Google Sheets

Insert multiple rows in spreadsheet (only for multiple items)

add the data to multiple rows in a Google Sheets spreadsheet

Premium Action
Google Sheets

Search rows in a spreadsheet

Search rows in a spreadsheet in Google Sheets

Search Column Required

Condition

Search value

Additional filters

Result limit

No rows found?

How it works

How the Google Sheets and Loja Integrada integration works

1. Trigger Loja Integrada Created order, Cancelled order, Paid order, Refunded payment
2. Action Google Sheets Insert row in spreadsheet, Insert multiple rows in spreadsheet (only for multiple items), Search rows in a spreadsheet, Insert/update row in spreadsheet

Trusted by over 10.000 amazing companies

Google Sheets

Google Sheets

Spreadsheet

Connect Google Sheets to 131+ apps with Pluga and turn your work into a productive machine. Centralize data from several apps in a single spreadsheet, keep your reports updated in real time and use the spreadsheet as a bridge between the apps you already work with.

Integrations with Google Sheets See more integrations with Spreadsheet Visit Google Sheets
Loja Integrada

Loja Integrada

Ecommerce

Connect Loja Integrada to 131+ apps with Pluga and turn your work into a productive machine. Automate order processing — created, paid, shipped or cancelled: each stage triggers the next steps, from customer notifications to finance and inventory entries.

Integrations with Loja Integrada See more integrations with Ecommerce Visit Loja Integrada

Frequently Asked Questions

  • With Pluga, you can easily automate Google Sheets with Loja Integrada . Just follow these steps:

    • 1. Log in or sign up (for free) on Pluga and click on “Create automation”;
    • 2. Select the source app and trigger;
    • 3. Select the destination app and action;
    • 4. Make the necessary adjustments, specifying which data will be sent to one app to another.
  • By automating Google Sheets with Loja Integrada on Pluga, you can automate various manual tasks that reduce productivity for those who perform them, while also avoiding human errors. The best part is that the process is simple and doesn’t require typing a single line of code.

  • On Pluga, you can make several automations for free with the free plan. Additionally, you have the option to try all the features for 7 days at no cost to create automations between Google Sheets, Loja Integrada, and even other apps.

    We also offer three other plans, with prices ranging from $17 to $71 per month, which include premium automations and features, as well as a higher volume of events and automations. For companies with specific needs, we have the Enterprise plan, designed to offer customized solutions beyond the resources available in other plans.

    Check Pluga's pricing page for more details.