Connect Stone with Google Sheets
Connect Stone with Google Sheets to scale and automate your operations.
Explore automation templates
Automate Stone and Google Sheets with Pluga integrations
Approved payment na Stone, add data to a new row on a Google Sheets spreadsheet
Approved payment na Stone, update or add data in Google Sheets spreadsheet's row(s)
Payment created in Stone, add data to a new row on a Google Sheets spreadsheet
Payment created in Stone, update or add data in Google Sheets spreadsheet's row(s)
Refunded payment in Stone, update or add data in Google Sheets spreadsheet's row(s)
Declined payment in Stone, add data to a new row on a Google Sheets spreadsheet
Declined payment in Stone, update or add data in Google Sheets spreadsheet's row(s)
Created subscription in Stone, add data to a new row on a Google Sheets spreadsheet
Created subscription in Stone, update or add data in Google Sheets spreadsheet's row(s)
When a new row is added on Google Sheets, create/update client in Stone
For each row created or updated in Google Sheets, create/update client in Stone
Didn't find the template you wanted? Build the integration your own way. ;)
Trusted by over 10.000 companies
Stone and Google Sheets
your way
Check out the available triggers and actions in the automation of apps Stone + Google Sheets
Approved payment
Approved payment na Stone
Payment ID
Payment code
Status
Payment method
Amount (in cents)
Amount
Amount (formatted in BRL)
Currency
Gateway ID
Creation date
Creation date (DD/MM/YYYY HH:MM:SS)
Customer: ID
Customer: name
Customer: email
Customer: document
Customer: type
Customer: mobile phone (country code)
Customer: mobile phone (area code)
Customer: mobile phone (number)
Customer address: street
Customer address: number
Customer address: neighborhood
Customer address: complement
Customer address: city
Customer address: state
Customer address: zip code
Customer address: country
Order: ID
Order: code
Item codes (comma separated)
Item descriptions (comma separated)
Item quantities (comma separated)
Item unit prices in cents (comma separated)
Item description, price and quantity
Shipping (in cents)
Shipping address: street
Shipping address: number
Shipping address: neighborhood
Shipping address: complement
Shipping address: city
Shipping address: state
Shipping address: zip code
Shipping address: country
Card: installments
Card: brand
Card: holder name
Card: first 6 digits
Card: last 4 digits
Card: expiration month
Card: expiration year
Card: type
Acquirer: name
Acquirer: return code
Acquirer: message
Acquirer: NSU
Acquirer: TID
Acquirer: authorization code
Billing address: street
Billing address: number
Billing address: neighborhood
Billing address: complement
Billing address: city
Billing address: state
Billing address: zip code
Billing address: country
Pix: copy and paste code
Pix: QR code image link
Pix: expiration date
Boleto: link
Boleto: PDF link
Boleto: digitable line
Boleto: barcode image link
Boleto: Pix QR code image link
Boleto: 'nosso número'
Boleto: due date
Boleto: bank
Boleto: instructions
Payment date
Payment date (DD/MM/YYYY HH:MM:SS)
Paid amount (in cents)
Paid amount
Paid amount (formatted in BRL)
Pix: transaction identifier (E2E)
Pix: payer name
Pix: payer document (partial)
Pix: payer document type
Pix: payer bank
Pix: payer bank ISPB
Created subscription
Created subscription in Stone
Subscription ID
Subscription code
Status
Payment method
Billing interval
Interval count
Billing type
Installments
Currency
Total amount (in cents)
Total amount
Total amount (formatted in BRL)
Creation date
Creation date (DD/MM/YYYY HH:MM:SS)
Start date
Start date (DD/MM/YYYY HH:MM:SS)
Next billing date
Next billing date (DD/MM/YYYY HH:MM:SS)
Current cycle: number
Current cycle: start
Current cycle: end
Current cycle: billing date
Customer: ID
Customer: name
Customer: email
Customer: document
Customer: type
Customer: mobile phone (country code)
Customer: mobile phone (area code)
Customer: mobile phone (number)
Customer address: street
Customer address: number
Customer address: neighborhood
Customer address: complement
Customer address: city
Customer address: state
Customer address: zip code
Customer address: country
Item IDs (comma separated)
Item descriptions (comma separated)
Item quantities (comma separated)
Item unit prices in cents (comma separated)
Item description, price and quantity
Card: brand
Card: holder name
For each row created/updated
For each row created or updated in Google Sheets
Nº da linha
Payment created
Payment created in Stone
Payment ID
Payment code
Status
Payment method
Amount (in cents)
Amount
Amount (formatted in BRL)
Currency
Gateway ID
Creation date
Creation date (DD/MM/YYYY HH:MM:SS)
Customer: ID
Customer: name
Customer: email
Customer: document
Customer: type
Customer: mobile phone (country code)
Customer: mobile phone (area code)
Customer: mobile phone (number)
Customer address: street
Customer address: number
Customer address: neighborhood
Customer address: complement
Customer address: city
Customer address: state
Customer address: zip code
Customer address: country
Order: ID
Order: code
Item codes (comma separated)
Item descriptions (comma separated)
Item quantities (comma separated)
Item unit prices in cents (comma separated)
Item description, price and quantity
Shipping (in cents)
Shipping address: street
Shipping address: number
Shipping address: neighborhood
Shipping address: complement
Shipping address: city
Shipping address: state
Shipping address: zip code
Shipping address: country
Card: installments
Card: brand
Card: holder name
Card: first 6 digits
Card: last 4 digits
Card: expiration month
Card: expiration year
Card: type
Acquirer: name
Acquirer: return code
Acquirer: message
Acquirer: NSU
Acquirer: TID
Acquirer: authorization code
Billing address: street
Billing address: number
Billing address: neighborhood
Billing address: complement
Billing address: city
Billing address: state
Billing address: zip code
Billing address: country
Pix: copy and paste code
Pix: QR code image link
Pix: expiration date
Boleto: link
Boleto: PDF link
Boleto: digitable line
Boleto: barcode image link
Boleto: Pix QR code image link
Boleto: 'nosso número'
Boleto: due date
Boleto: bank
Boleto: instructions
Declined payment
Declined payment in Stone
Payment ID
Payment code
Status
Payment method
Amount (in cents)
Amount
Amount (formatted in BRL)
Currency
Gateway ID
Creation date
Creation date (DD/MM/YYYY HH:MM:SS)
Customer: ID
Customer: name
Customer: email
Customer: document
Customer: type
Customer: mobile phone (country code)
Customer: mobile phone (area code)
Customer: mobile phone (number)
Customer address: street
Customer address: number
Customer address: neighborhood
Customer address: complement
Customer address: city
Customer address: state
Customer address: zip code
Customer address: country
Order: ID
Order: code
Item codes (comma separated)
Item descriptions (comma separated)
Item quantities (comma separated)
Item unit prices in cents (comma separated)
Item description, price and quantity
Shipping (in cents)
Shipping address: street
Shipping address: number
Shipping address: neighborhood
Shipping address: complement
Shipping address: city
Shipping address: state
Shipping address: zip code
Shipping address: country
Card: installments
Card: brand
Card: holder name
Card: first 6 digits
Card: last 4 digits
Card: expiration month
Card: expiration year
Card: type
Acquirer: name
Acquirer: return code
Acquirer: message
Acquirer: NSU
Acquirer: TID
Acquirer: authorization code
Billing address: street
Billing address: number
Billing address: neighborhood
Billing address: complement
Billing address: city
Billing address: state
Billing address: zip code
Billing address: country
Pix: copy and paste code
Pix: QR code image link
Pix: expiration date
Boleto: link
Boleto: PDF link
Boleto: digitable line
Boleto: barcode image link
Boleto: Pix QR code image link
Boleto: 'nosso número'
Boleto: due date
Boleto: bank
Boleto: instructions
Refusal reason
Transaction status
Antifraud: status
Antifraud: score
Refunded payment
Refunded payment in Stone
Payment ID
Payment code
Status
Payment method
Amount (in cents)
Amount
Amount (formatted in BRL)
Currency
Gateway ID
Creation date
Creation date (DD/MM/YYYY HH:MM:SS)
Customer: ID
Customer: name
Customer: email
Customer: document
Customer: type
Customer: mobile phone (country code)
Customer: mobile phone (area code)
Customer: mobile phone (number)
Customer address: street
Customer address: number
Customer address: neighborhood
Customer address: complement
Customer address: city
Customer address: state
Customer address: zip code
Customer address: country
Order: ID
Order: code
Item codes (comma separated)
Item descriptions (comma separated)
Item quantities (comma separated)
Item unit prices in cents (comma separated)
Item description, price and quantity
Shipping (in cents)
Shipping address: street
Shipping address: number
Shipping address: neighborhood
Shipping address: complement
Shipping address: city
Shipping address: state
Shipping address: zip code
Shipping address: country
Card: installments
Card: brand
Card: holder name
Card: first 6 digits
Card: last 4 digits
Card: expiration month
Card: expiration year
Card: type
Acquirer: name
Acquirer: return code
Acquirer: message
Acquirer: NSU
Acquirer: TID
Acquirer: authorization code
Billing address: street
Billing address: number
Billing address: neighborhood
Billing address: complement
Billing address: city
Billing address: state
Billing address: zip code
Billing address: country
Pix: copy and paste code
Pix: QR code image link
Pix: expiration date
Boleto: link
Boleto: PDF link
Boleto: digitable line
Boleto: barcode image link
Boleto: Pix QR code image link
Boleto: 'nosso número'
Boleto: due date
Boleto: bank
Boleto: instructions
Payment date
Payment date (DD/MM/YYYY HH:MM:SS)
Paid amount (in cents)
Paid amount
Paid amount (formatted in BRL)
Pix: transaction identifier (E2E)
Pix: payer name
Pix: payer document (partial)
Pix: payer document type
Pix: payer bank
Pix: payer bank ISPB
Refund date
Refund date (DD/MM/YYYY HH:MM:SS)
Refunded amount (in cents)
Refunded amount
Refunded amount (formatted in BRL)
New added row
When a new row is added on Google Sheets
Line No.
Create/update client
Create/update client in Stone
Customer name Required
Customer email Required
Customer CPF/CNPJ
Gender
Birthdate
Mobile phone: country code
Mobile phone: area code
Mobile phone: number
Address: street
Address: number
Address: neighborhood
Address: complement
Address: zip code
Address: city
Address: state
Address: country
Search rows in a spreadsheet
Search rows in a spreadsheet in Google Sheets
Search Column Required
Condition
Search value
Additional filters
Result limit
Start at row
Order
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
Boost this flow in your workflow
With Pluga, you connect Stone + Google Sheets 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 row created or updated in Google Sheets".
- Basic 2
Set the destinations and the actions
Select the apps that make up the flow with Stone and what Pluga should run automatically at each step. Example: "Create/update client in Stone"
- 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
Stone
AccountingConnect Stone to 135+ apps with Pluga and turn your work into a productive machine. Automate income and expense entries, settle receipts as soon as payment clears and keep payables and receivables current — without spending hours closing the month by hand.
Google Sheets
SpreadsheetConnect Google Sheets to 135+ 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.
