Connect Google Sheets with iugu
Connect Google Sheets with iugu to scale and automate your operations.
Explore automation templates
Automate Google Sheets and iugu with Pluga integrations
For each approved payment on iugu, add data to a new row on a Google Sheets spreadsheet
For each canceled payment on iugu, add data to a new row on a Google Sheets spreadsheet
For each refunded payment on iugu, add data to a new row on a Google Sheets spreadsheet
For each created payment on iugu, add data to a new row on a Google Sheets spreadsheet
When a new row is created on Google Sheets, create a customer on iugu
When an invoice is due on iugu, add data to a new row on a Google Sheets spreadsheet
When a new row is created on Google Sheets, send a billing to the customer via iugu
For each expired payment on iugu, add data to a new row on a Google Sheets spreadsheet
For each created subscription on iugu, add data to a new row on a Google Sheets spreadsheet
For each approved payment on iugu, update or add data in a new row of a Google Sheets spreadsheet
For each canceled payment on iugu, update or add data in a new row of a Google Sheets spreadsheet
For each refunded payment on iugu, update or add data in a new row of a Google Sheets spreadsheet
For each created payment on iugu, update or add data in a new row of a Google Sheets spreadsheet
When an invoice is due on iugu, update or add data in a new row of a Google Sheets spreadsheet
For each expired payment on iugu, update or add data in a new row of a Google Sheets spreadsheet
For each created subscription on iugu, update or add data in a new row of a Google Sheets spreadsheet
For each row created or updated in Google Sheets, create a customer on iugu
For each row created or updated in Google Sheets, send a billing to the customer via iugu
For each approved payment on iugu, add the data to multiple rows in a Google Sheets spreadsheet
Didn't find the template you wanted? Build the integration your own way. ;)
Trusted by over 10.000 amazing companies
Google Sheets and iugu
your way
Check out the available triggers and actions in the automation of apps Google Sheets + iugu
New added row
When a new row is added on Google Sheets
Line No.
Overdue invoice
When an invoice is due on iugu
Invoice items
transaction id
due date (formatted - DD/MM/YYYY)
status
coin
amount of items in cents
discount in cents
iugu fees (cents)
iugu fees (decimal)
iugu fees (text)
total amount (cents)
installments
total amount in Reais (decimal separated by dot)
total amount in Reais (decimal separated by comma)
total amount in Reais in the format "R$ 10.00"
payment amount (cents)
payment amount (decimal)
payment amount (text)
marketplace commission (cents)
marketplace commission (decimal)
marketplace commission (text)
fine and interest (cents)
fine and interest (decimal)
fine and interest (text)
created in (YYYY-MM-DDTHH:mm:ss-Z)
created on (DD/MM/YYYY)
created in (H:M:S)
created in (DD/MM/YYYY - H:M:S)
updated in (YYYY-MM-DDTHH:mm:ss-Z)
updated on (DD/MM/YYYY)
updated in (H:M:S)
updated in (DD/MM/YYYY - H:M:S)
paid in (YYYY-MM-DDTHH:mm:ss-Z)
paid in (DD/MM/YYYY)
paid in (H:M:S)
paid in (DD/MM/YYYY - H:M:S)
invoice url
customer id
bank slip (link)
payment method
Customer Subscription ID
Purchase order ID
items description
items quantity
items description, quantity and price
cpf or cnpj
buyer email
CC emails buyer
Buyer's Notes
buyer name
buyer's telephone number (DDD)
buyer telephone number (number)
address street
address: number
full address
address neighborhood
address: city
address: state
address: country
address: Zip Code
Approved payment
For each approved payment on iugu
Invoice items
transaction id
due date (formatted - DD/MM/YYYY)
status
coin
amount of items in cents
discount in cents
iugu fees (cents)
iugu fees (decimal)
iugu fees (text)
total amount (cents)
installments
total amount in Reais (decimal separated by dot)
total amount in Reais (decimal separated by comma)
total amount in Reais in the format "R$ 10.00"
payment amount (cents)
payment amount (decimal)
payment amount (text)
marketplace commission (cents)
marketplace commission (decimal)
marketplace commission (text)
fine and interest (cents)
fine and interest (decimal)
fine and interest (text)
created in (YYYY-MM-DDTHH:mm:ss-Z)
created on (DD/MM/YYYY)
created in (H:M:S)
created in (DD/MM/YYYY - H:M:S)
updated in (YYYY-MM-DDTHH:mm:ss-Z)
updated on (DD/MM/YYYY)
updated in (H:M:S)
updated in (DD/MM/YYYY - H:M:S)
paid in (YYYY-MM-DDTHH:mm:ss-Z)
paid in (DD/MM/YYYY)
paid in (H:M:S)
paid in (DD/MM/YYYY - H:M:S)
invoice url
customer id
bank slip (link)
payment method
Customer Subscription ID
Purchase order ID
items description
items quantity
items description, quantity and price
cpf or cnpj
buyer email
CC emails buyer
Buyer's Notes
buyer name
buyer's telephone number (DDD)
buyer telephone number (number)
address street
address: number
full address
address neighborhood
address: city
address: state
address: country
address: Zip Code
financial return date
Date, amount and taxes of financial returns separated by commas
Duplicate invoice
Duplicate original invoice ID
Created subscription
For each created subscription on iugu
Signature: ID
Signature: Plan identifier
Subscription: Price in cents
Subscription: Currency
Customer: ID
Customer: Email
Customer: Name
Customer: Notes
Customer: CPF/CNPJ
Customer: Zip Code
Customer: Address number
Customer: Address complement
Customer: Rua
Customer: Neighborhood
Customer: Telephone
Customer: Telephone (DDD)
Customer: City
Customer: State
Signature: Date of creation (in the format YYYY-MM-DDTHH:mm:ss-Z)
Signature: Creation date (DD/MM/YYYY)
Signature: Creation time (H:M:S)
Signature: Date created (DD/MM/YYYY - H:M:S)
Signature: Update date (in the format YYYY-MM-DDTHH:mm:ss-Z)
Signature: Update date (DD/MM/YYYY)
Signature: Update time (H:M:S)
Signature: Update date (in the format DD/MM/YYYY - H:M:S)
Subscription: Description of items
Subscription: Quantity of items
Signature: Description of items, quantity and price
Subscription: Price (R$)
For each row created/updated
For each row created or updated in Google Sheets
Nº da linha
Payment canceled
For each canceled payment on iugu
Invoice items
transaction id
due date (formatted - DD/MM/YYYY)
status
coin
amount of items in cents
discount in cents
iugu fees (cents)
iugu fees (decimal)
iugu fees (text)
total amount (cents)
installments
total amount in Reais (decimal separated by dot)
total amount in Reais (decimal separated by comma)
total amount in Reais in the format "R$ 10.00"
payment amount (cents)
payment amount (decimal)
payment amount (text)
marketplace commission (cents)
marketplace commission (decimal)
marketplace commission (text)
fine and interest (cents)
fine and interest (decimal)
fine and interest (text)
created in (YYYY-MM-DDTHH:mm:ss-Z)
created on (DD/MM/YYYY)
created in (H:M:S)
created in (DD/MM/YYYY - H:M:S)
updated in (YYYY-MM-DDTHH:mm:ss-Z)
updated on (DD/MM/YYYY)
updated in (H:M:S)
updated in (DD/MM/YYYY - H:M:S)
paid in (YYYY-MM-DDTHH:mm:ss-Z)
paid in (DD/MM/YYYY)
paid in (H:M:S)
paid in (DD/MM/YYYY - H:M:S)
invoice url
customer id
bank slip (link)
payment method
Customer Subscription ID
Purchase order ID
items description
items quantity
items description, quantity and price
cpf or cnpj
buyer email
CC emails buyer
Buyer's Notes
buyer name
buyer's telephone number (DDD)
buyer telephone number (number)
address street
address: number
full address
address neighborhood
address: city
address: state
address: country
address: Zip Code
referência externa
Refunded invoice
For each refunded payment on iugu
Invoice items
transaction id
due date (formatted - DD/MM/YYYY)
status
coin
amount of items in cents
discount in cents
iugu fees (cents)
iugu fees (decimal)
iugu fees (text)
total amount (cents)
installments
total amount in Reais (decimal separated by dot)
total amount in Reais (decimal separated by comma)
total amount in Reais in the format "R$ 10.00"
payment amount (cents)
payment amount (decimal)
payment amount (text)
marketplace commission (cents)
marketplace commission (decimal)
marketplace commission (text)
fine and interest (cents)
fine and interest (decimal)
fine and interest (text)
created in (YYYY-MM-DDTHH:mm:ss-Z)
created on (DD/MM/YYYY)
created in (H:M:S)
created in (DD/MM/YYYY - H:M:S)
updated in (YYYY-MM-DDTHH:mm:ss-Z)
updated on (DD/MM/YYYY)
updated in (H:M:S)
updated in (DD/MM/YYYY - H:M:S)
paid in (YYYY-MM-DDTHH:mm:ss-Z)
paid in (DD/MM/YYYY)
paid in (H:M:S)
paid in (DD/MM/YYYY - H:M:S)
invoice url
customer id
bank slip (link)
payment method
Customer Subscription ID
Purchase order ID
items description
items quantity
items description, quantity and price
cpf or cnpj
buyer email
CC emails buyer
Buyer's Notes
buyer name
buyer's telephone number (DDD)
buyer telephone number (number)
address street
address: number
full address
address neighborhood
address: city
address: state
address: country
address: Zip Code
Created payment
For each created payment on iugu
Invoice items
transaction id
due date (formatted - DD/MM/YYYY)
status
coin
amount of items in cents
discount in cents
iugu fees (cents)
iugu fees (decimal)
iugu fees (text)
total amount (cents)
installments
total amount in Reais (decimal separated by dot)
total amount in Reais (decimal separated by comma)
total amount in Reais in the format "R$ 10.00"
payment amount (cents)
payment amount (decimal)
payment amount (text)
marketplace commission (cents)
marketplace commission (decimal)
marketplace commission (text)
fine and interest (cents)
fine and interest (decimal)
fine and interest (text)
created in (YYYY-MM-DDTHH:mm:ss-Z)
created on (DD/MM/YYYY)
created in (H:M:S)
created in (DD/MM/YYYY - H:M:S)
updated in (YYYY-MM-DDTHH:mm:ss-Z)
updated on (DD/MM/YYYY)
updated in (H:M:S)
updated in (DD/MM/YYYY - H:M:S)
paid in (YYYY-MM-DDTHH:mm:ss-Z)
paid in (DD/MM/YYYY)
paid in (H:M:S)
paid in (DD/MM/YYYY - H:M:S)
invoice url
customer id
bank slip (link)
payment method
Customer Subscription ID
Purchase order ID
items description
items quantity
items description, quantity and price
cpf or cnpj
buyer email
CC emails buyer
Buyer's Notes
buyer name
buyer's telephone number (DDD)
buyer telephone number (number)
address street
address: number
full address
address neighborhood
address: city
address: state
address: country
address: Zip Code
slip (digital line)
QR code (link)
QR code (text)
Expired payment
For each expired payment on iugu
Invoice items
transaction id
due date (formatted - DD/MM/YYYY)
status
coin
amount of items in cents
discount in cents
iugu fees (cents)
iugu fees (decimal)
iugu fees (text)
total amount (cents)
installments
total amount in Reais (decimal separated by dot)
total amount in Reais (decimal separated by comma)
total amount in Reais in the format "R$ 10.00"
payment amount (cents)
payment amount (decimal)
payment amount (text)
marketplace commission (cents)
marketplace commission (decimal)
marketplace commission (text)
fine and interest (cents)
fine and interest (decimal)
fine and interest (text)
created in (YYYY-MM-DDTHH:mm:ss-Z)
created on (DD/MM/YYYY)
created in (H:M:S)
created in (DD/MM/YYYY - H:M:S)
updated in (YYYY-MM-DDTHH:mm:ss-Z)
updated on (DD/MM/YYYY)
updated in (H:M:S)
updated in (DD/MM/YYYY - H:M:S)
paid in (YYYY-MM-DDTHH:mm:ss-Z)
paid in (DD/MM/YYYY)
paid in (H:M:S)
paid in (DD/MM/YYYY - H:M:S)
invoice url
customer id
bank slip (link)
payment method
Customer Subscription ID
Purchase order ID
items description
items quantity
items description, quantity and price
cpf or cnpj
buyer email
CC emails buyer
Buyer's Notes
buyer name
buyer's telephone number (DDD)
buyer telephone number (number)
address street
address: number
full address
address neighborhood
address: city
address: state
address: country
address: Zip Code
Partially paid payment
For each partially paid payment on iugu
Invoice items
transaction id
due date (formatted - DD/MM/YYYY)
status
coin
amount of items in cents
discount in cents
iugu fees (cents)
iugu fees (decimal)
iugu fees (text)
total amount (cents)
installments
total amount in Reais (decimal separated by dot)
total amount in Reais (decimal separated by comma)
total amount in Reais in the format "R$ 10.00"
payment amount (cents)
payment amount (decimal)
payment amount (text)
marketplace commission (cents)
marketplace commission (decimal)
marketplace commission (text)
fine and interest (cents)
fine and interest (decimal)
fine and interest (text)
created in (YYYY-MM-DDTHH:mm:ss-Z)
created on (DD/MM/YYYY)
created in (H:M:S)
created in (DD/MM/YYYY - H:M:S)
updated in (YYYY-MM-DDTHH:mm:ss-Z)
updated on (DD/MM/YYYY)
updated in (H:M:S)
updated in (DD/MM/YYYY - H:M:S)
paid in (YYYY-MM-DDTHH:mm:ss-Z)
paid in (DD/MM/YYYY)
paid in (H:M:S)
paid in (DD/MM/YYYY - H:M:S)
invoice url
customer id
bank slip (link)
payment method
Customer Subscription ID
Purchase order ID
items description
items quantity
items description, quantity and price
cpf or cnpj
buyer email
CC emails buyer
Buyer's Notes
buyer name
buyer's telephone number (DDD)
buyer telephone number (number)
address street
address: number
full address
address neighborhood
address: city
address: state
address: country
address: Zip Code
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
Create customer
create a customer on iugu
Customer name Required
Customer email Required
Other emails
Notes
customer cpf/cnpj Required
address street
address: number
full address
address neighborhood
address: city
address: state
address: Zip Code
telephone: area code
telephone number
Customer ID
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?
Create billing
send a billing to the customer via iugu
Email Required
Other emails
Payment deadline (days) Required
Item Description Required
Item Quantity Required
Item Price Required
Available payment methods Required
Maximum number of installments
Customer name
Customer notes
Customer document
Address street
Address: number
full address
address neighborhood
address: city
address: state
address: Zip Code
Telephone: area code
Telephone number
Boost this flow in your workflow
With Pluga, you connect Google Sheets + iugu 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 created payment on iugu".
- 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: "Search rows in a spreadsheet in Google Sheets"
- 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.
iugu
PaymentConnect iugu to 133+ apps with Pluga and turn your work into a productive machine. Generate invoices as soon as a deal closes and automate what happens with payment data: notify the customer, settle it in your finance app and log it in your CRM. You can also push sales records out to keep cash flow dashboards always up to date.
