Connect Nibo with Google Sheets

Connect Nibo with Google Sheets to scale and automate your operations.

Explore automation templates

Automate Nibo and Google Sheets
with Pluga integrations

Trusted by over 10.000 amazing companies

Nibo and Google Sheets
your way

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

Trigger
Google Sheets

New added row

When a new row is added on Google Sheets

Line No.

Trigger
Google Sheets

For each row created/updated

For each row created or updated in Google Sheets

Nº da linha

Action
Nibo

Generate account receivable

create a new bills to receive in Nibo

Company Required

description Required

reference

Amount Required

Schedule date Required

Due date Required

Accrual date

Category selection mode

Category

Category

Cost center selection

Cost center id

Cost center description

Number of installments

Contact update criteria

Customer name. Required

Customer email.

Customer Document Number.

Customer phone number.

Customer's cell phone.

Customer address

Customer address number

Customer address complement

Customer address neighborhood

City of customer address

Customer address state

Customer address Zip Code

Country of customer address

Service profile

Auto generate NFS-e type

Days before due date to generate NFS-e

State where service was provided

City where service was provided

Action
Nibo

Include expense

create a new payment in Nibo

Company Required

Account Required

Category selection mode

Category

Category

Cost center selection

Cost Centers

Cost center description

Amount Required

Entry date Required

description Required

Contact update criteria

Supplier's Name Required

Supplier's Email

Supplier's Document Number

Supplier's Phone

Supplier's Cellphone

Supplier's Address

Supplier's address number

Supplier's address complement

Supplier's address district

Supplier's address city

Supplier's address state

Supplier's address zip code

Supplier's address country

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
Nibo

Register customer

create a new customer in Nibo

Company Required

Contact update criteria

Name Required

Email

Document

Customer phone number.

Customer's cell phone.

Customer address

Customer address number

Customer address complement

Customer address neighborhood

City of customer address

Customer address state

Customer address Zip Code

Country of customer address

Action
Nibo

Register vendor

create a new supplier in Nibo

Company Required

Contact update criteria

Name Required

Email

Document

Customer phone number.

Customer's cell phone.

Customer address

Customer address number

Customer address complement

Customer address neighborhood

City of customer address

Customer address state

Customer address Zip Code

Country of customer address

Action
Google Sheets

Insert multiple rows in spreadsheet (only for multiple items)

add the data to multiple rows in a Google Sheets spreadsheet

Action
Nibo

Include receipt

create a new receipt in Nibo

Company Required

Account Required

Category selection mode

Category

Category

Cost center selection

Cost Centers

value

Amount Required

Entry date Required

description Required

Contact update criteria

Customer name Required

Customer email

Customer Document Number

Customer phone number

Customer's cell phone

Customer address

Customer address number

Customer address complement

Customer address neighborhood

City of customer address

Customer address state

Customer address Zip Code

Country of customer address

Action
Nibo

Create an accounts payable

Create payable in Nibo

Organization Required

Vendor Required

Amount Required

Due date Required

Description

Accrual date

Reference

Category

Cost center

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 to integrate Nibo and Google Sheets on Pluga

Boost this flow in your workflow

With Pluga, you connect Nibo + 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 Nibo and what Pluga should run automatically at each step. Example: "create a new payment in Nibo"

  • 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

Nibo

Nibo

Accounting

Connect Nibo to 133+ 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

Google Sheets

Spreadsheet

Connect 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.

Frequently Asked Questions

  • By automating Nibo with Google Sheets 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 Nibo, Google Sheets, 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.