Connect Google Sheets with Bom Controle
Connect Google Sheets with Bom Controle to scale and automate your operations.
Explore automation templates
Automate Google Sheets and Bom Controle with Pluga integrations
New sale in Bom Controle, add or update data in Google Sheets spreadsheet's row(s)
New sale in Bom Controle, add data to a new row on a Google Sheets spreadsheet
New sale in Bom Controle, update or add data in Google Sheets spreadsheet's row(s)
New sale in Bom Controle, add the data to multiple rows in a Google Sheets spreadsheet
New receivable in Bom Controle, add data to a new row on a Google Sheets spreadsheet
New receivable in Bom Controle, update or add data in Google Sheets spreadsheet's row(s)
When a new row is added on Google Sheets, create or update client in Bom Controle
For each row created or updated in Google Sheets, create or update client in Bom Controle
Didn't find the template you wanted? Build the integration your own way. ;)
Trusted by over 10.000 amazing companies
Google Sheets and Bom Controle
your way
Check out the available triggers and actions in the automation of apps Google Sheets + Bom Controle
New added row
When a new row is added on Google Sheets
Line No.
New receivable
New receivable in Bom Controle
Movement ID
Client ID
Client name
Amount
Due date
Payment method
Financial category
Financial account
Installments
Receivable status
For each row created/updated
For each row created or updated in Google Sheets
Nº da linha
New sale
New sale in Bom Controle
Invoice ID
Movement ID
Movement description
Notes
Movement type code
Movement type
Installment amount
Gross amount
Discount amount
Surcharge amount
Installment number
Total installments
Due date
Accrual date
Installment creation date
Billing date
Payment method code
Payment method
Client ID
Client name
Client's trade name
Client's document (CPF/CNPJ)
Document number
Bank slip (boleto) link
Service invoice link
Product invoice number
Company ID
Company name
Receivable paid
Receivable paid in Bom Controle
Movement ID
Client ID
Client name
Paid amount
Due date
Payment date
Payment method
Financial category
Financial account
Installment number
Total installments
Notes
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)
Create receivable
Create receivable in Bom Controle
Financial account Required
Financial category Required
Client: Registration data update
Client: Update criterion
Client: CNPJ or CPF Required
Client: Legal name or full name Required
Client: Trade name
Amount Required
First due date Required
Payment method Required
Installments
Notes
Insert multiple rows in spreadsheet (only for multiple items)
add the data to multiple rows in a Google Sheets spreadsheet
Create/update client
Create or update client in Bom Controle
Create or update the client?
Client uniqueness criterion
Person type Required
Legal name or full name Required
CNPJ or CPF Required
Contact email
Contact phone
Contact name
Trade name
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 payable
Create payable in Bom Controle
Financial account Required
Expense financial category Required
Supplier: Registration data update
Supplier: Update criterion
Supplier: CNPJ or CPF Required
Supplier: Legal name or full name Required
Supplier: Trade name
Amount Required
First due date Required
Payment method
Number of installments
Notes
Boost this flow in your workflow
With Pluga, you connect Google Sheets + Bom Controle 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 Bom Controle and what Pluga should run automatically at each step. Example: "Create receivable in Bom Controle"
- 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.
Bom Controle
ERPConnect Bom Controle to 133+ apps with Pluga and turn your work into a productive machine. Sync customer and supplier records, create sales and purchase orders and settle receivables. Keep finance and inventory up to date, automatically.
