Connect Google Sheets with Yampi
Connect Google Sheets with Yampi to scale and automate your operations.
Explore automation templates
Automate Google Sheets and Yampi with Pluga integrations
For each new created order on Yampi, add data to a new row on a Google Sheets spreadsheet
For each paid order on Yampi, add data to a new row on a Google Sheets spreadsheet
For each new created order on Yampi, update or add data in a new row of a Google Sheets spreadsheet
For each paid order on Yampi, update or add data in a new row of a Google Sheets spreadsheet
For each order canceled on Yampi, add data to a new row on a Google Sheets spreadsheet
For each order canceled on Yampi, update or add data in Google Sheets spreadsheet's row(s)
Didn't find the template you wanted? Build the integration your own way. ;)
Trusted by over 10.000 amazing companies
Google Sheets and Yampi
your way
Check out the available triggers and actions in the automation of apps Google Sheets + Yampi
New added row
When a new row is added on Google Sheets
Line No.
Paid order
For each paid order on Yampi
Order items
Order: Status
Order: Number
Order: Total amount
Order: Subtotal of products
Order: Shipping cost
Order: Discount amount
Order: Fee amount
Delivery: Deadline (in days)
Order: Creation date and time
Order: Creation time zone
Order: Date and time of creation in the format (DD/MM/YYYY - H:M:S)
Order: Creation date in format (DD/MM/YYYY)
Order: Creation time in format (H:M:S)
Delivery: Estimated date and time
Delivery: Forecast time zone
Delivery: Estimated date and time in the format (DD/MM/YYYY - H:M:S)
Delivery: Expected date in the format (DD/MM/YYYY)
Delivery: Estimated time not format (H:M:S)
Customer: IP number
Delivery: ID
Delivery: Street
Delivery: Number
Delivery: Neighborhood
Delivery: Person who will receive the order
Delivery: Zip Code
Delivery: Complement
Delivery: City
Delivery: State
Delivery: UF
Delivery: Country
Delivery: Full address
Delivery: Shipping service
Customer: ID
Customer: Name
Customer: First name
Customer: Last name
Customer: Email
Customer: CPF
Customer: CNPJ
Customer: Company name
Customer: Birthday date
Customer: Telephone/Cell phone with area code without formatting (e.g.: 21999999999)
Customer: Telephone/Cellular area code
Customer: Telephone/Cellphone
Customer: Telephone/Cell phone with formatted area code (e.g.: (21) 99999-9999)
Customer: Whatsapp Link
Order: Name of products (separated by comma)
Order: SKU code of the products (separated by a comma)
Order: Price of products (separated by comma)
Order: Quantity of products purchased (separated by commas)
Order: [SKUs] Name - price x quantity of products (separated by commas)
Order: Product customizations (separated by a comma in the format 'customization name - customer choice')
Transaction: Holder's name
Transaction: Installments
Transaction: Installment amount
Transaction: Quantity and amount of installments (e.g. 2x of R$ 200.00)
Transaction: Payment type
Order: Coupon code used
Order: Description of the coupon used
Transaction: Payment date and time
Transaction: Payment time zone
Transaction: Date and time of payment in the format (DD/MM/YYYY - H:M:S)
Transaction: Payment date in the format (DD/MM/YYYY)
Transaction: Payment time in the format (H:M:S)
For each row created/updated
For each row created or updated in Google Sheets
Nº da linha
Order canceled
For each order canceled on Yampi
Order items
Order: Status
Order: Number
Order: Total amount
Order: Subtotal of products
Order: Shipping cost
Order: Discount amount
Order: Fee amount
Delivery: Deadline (in days)
Order: Creation date and time
Order: Creation time zone
Order: Date and time of creation in the format (DD/MM/YYYY - H:M:S)
Order: Creation date in format (DD/MM/YYYY)
Order: Creation time in format (H:M:S)
Delivery: Estimated date and time
Delivery: Forecast time zone
Delivery: Estimated date and time in the format (DD/MM/YYYY - H:M:S)
Delivery: Expected date in the format (DD/MM/YYYY)
Delivery: Estimated time not format (H:M:S)
Customer: IP number
Delivery: ID
Delivery: Street
Delivery: Number
Delivery: Neighborhood
Delivery: Person who will receive the order
Delivery: Zip Code
Delivery: Complement
Delivery: City
Delivery: State
Delivery: UF
Delivery: Country
Delivery: Full address
Delivery: Shipping service
Customer: ID
Customer: Name
Customer: First name
Customer: Last name
Customer: Email
Customer: CPF
Customer: CNPJ
Customer: Company name
Customer: Birthday date
Customer: Telephone/Cell phone with area code without formatting (e.g.: 21999999999)
Customer: Telephone/Cellular area code
Customer: Telephone/Cellphone
Customer: Telephone/Cell phone with formatted area code (e.g.: (21) 99999-9999)
Customer: Whatsapp Link
Order: Name of products (separated by comma)
Order: SKU code of the products (separated by a comma)
Order: Price of products (separated by comma)
Order: Quantity of products purchased (separated by commas)
Order: [SKUs] Name - price x quantity of products (separated by commas)
Order: Product customizations (separated by a comma in the format 'customization name - customer choice')
Transaction: Holder's name
Transaction: Installments
Transaction: Installment amount
Transaction: Quantity and amount of installments (e.g. 2x of R$ 200.00)
Transaction: Payment type
Order: Coupon code used
Order: Description of the coupon used
Created order
For each new created order on Yampi
Order items
Order: Current status
Order number
Order: Total amount
Order: Subtotal of products
Order: Shipping cost
Order: Discount amount
Request: Fee amount
Order: Deadline (in days) for delivery
Order: Creation date and time
Request: Creation time zone
Order: Date and time of creation in the format (DD/MM/YYYY - H:M:S)
Order: Creation date in format (DD/MM/YYYY)
Order: Creation time in format (H:M:S)
Delivery: Estimated date and time
Delivery: Forecast time zone
Delivery: Expected date and time in the format (DD/MM/YYYY - H:M:S)
Delivery: Expected date in the format (DD/MM/YYYY)
Delivery: Estimated time not format (H:M:S)
Customer: IP number
Delivery: ID
Delivery: Street
Delivery: Number
Delivery: Neighborhood
Delivery: Person who will receive the order
Delivery: Zip Code
Delivery: Complement
Delivery: City
Delivery: State
Delivery: UF
Delivery: Country
Delivery: Full address
Delivery: Shipping service
Customer: ID
Customer: Name
Customer: First name
Customer: Last name
Customer: Email
Customer: CPF
Customer: CNPJ
Customer: Company name
Customer: Birthday date
Customer: Telephone/Mobile: number with area code without formatting (e.g.: 21999999999)
Customer: DDD Telephone/Cellular
Customer: Telephone/Cellular
Customer: Telephone/Cell phone with formatted area code (e.g.: (21) 99999-9999)
Customer: Link Whatsapp
Order: Name of items (separated by comma)
Order: SKU code of the products (separated by a comma)
Order: Price of products (separated by comma)
Order: Quantity of products purchased (separated by comma)
Order: [SKUs] Name - price x quantity of products (separated by commas)
Order: Customizations (separated by a comma in the format 'customization name - customer choice')
Transaction: Holder's name
Transaction: Installments
Transaction: Installment amount
Transaction: Quantity and amount of installments (e.g. 2x of R$ 200.00)
Order: Payment type used
Insert row in spreadsheet
add data to a new row on a Google Sheets spreadsheet
Columns
Insert/update row in spreadsheet
add or update data in Google Sheets spreadsheet's row(s)
Insert multiple rows in spreadsheet (only for multiple items)
add the data to multiple rows in a Google Sheets spreadsheet
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?
Boost this flow in your workflow
With Pluga, you connect Google Sheets + Yampi to build anything from the simplest integration to the most advanced flows, with several layers of logic.
- Basic 1
Pick the source app and the trigger
Choose which app starts the automation and which event works as the trigger. For example, "For each paid order on Yampi".
- Basic 2
Set the destinations and the actions
Select the apps that make up the flow with Google Sheets and what Pluga should run automatically at each step. Example: "add the data to multiple rows in a Google Sheets spreadsheet"
- Basic 3
Map the information
Point out, visually, which data from the source app should fill in each field of the destination action.
- Intermediate
Only move forward when it makes sense
Set "AND" or "OR" conditions so the automation only runs in the cases that matter
- Intermediate
Pause the flow for as long as you need
Set the automation to wait minutes, hours or days and resume the next action on its own
- Intermediate
Standardize data across apps
Adjust dates, numbers and characters to the format the next app expects to receive
- Advanced
Send data in several directions
Route each piece of data down the right path within a single flow, according to specific conditions
- Advanced
Add a code block
Run JavaScript or Python in the middle of the automation to transform data before the next step
- Advanced
Create loops
Take lists of items, go through each row and run the same action for every one of them
- Advanced
Use generative AI
Send data to an AI assistant or agent and use the response in the next step
- Advanced
Connect to (almost) any app
Send and receive data through a dedicated URL, and connect to apps that are not integrated with Pluga
- Advanced
Requests to external APIs
Query or send data to any external API inside your automation
Google Sheets
SpreadsheetConnect Google Sheets to 133+ 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.
Yampi
E-commerceConnect Yampi to 133+ 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.
