arrow_backAll integrations
Data and reporting

Google Sheets integration

Write Perno transaction and commerce data into Google Sheets.

Connect Google Sheets
P
sync_alt
GO
Why connect it

Make Google Sheets part of the workflow, not another manual destination.

Build lightweight reports and operational registers by appending or updating spreadsheet rows whenever Perno records an important event.
settings_suggest

Set up once, reuse everywhere

Authorize Google Sheets with OAuth, select a spreadsheet and map event fields to rows in an automation step.
  1. 1Add and authorize the organization connection.
  2. 2Choose the Perno event that starts the automation.
  3. 3Map event data to one of the actions below.
Action catalogue

What Perno can do in Google Sheets

Write

Append Sheet Rows

bolt

Append rows to an existing Google Sheets spreadsheet.

rowsrangespreadsheet_id
Write

Create Sheet

bolt

Create a Google Sheets spreadsheet and optionally write initial rows.

rowsrangetitle
Read

Find Sheet Rows

bolt

Find rows in a Google Sheets range containing a query string.

limitqueryrangespreadsheet_id
Read

Read Sheet Values

bolt

Read values from an existing Google Sheets spreadsheet.

rangespreadsheet_id
Write

Write Sheet Values

bolt

Write/replace values in an existing Google Sheets spreadsheet range.

rowsrangespreadsheet_id

Popular ways to connect Google Sheets

Stripe → Google Sheets

Stripe Google Sheets Integration

Connect Stripe payment events with Google Sheets. Move transaction data automatically, reduce manual updates and keep every team in sync.

PayU → Google Sheets

PayU Google Sheets Integration

Connect PayU payment events with Google Sheets. Move transaction data automatically, reduce manual updates and keep every team in sync.

Autopay → Google Sheets

Autopay Google Sheets Integration

Connect Autopay payment events with Google Sheets. Move transaction data automatically, reduce manual updates and keep every team in sync.

OLX → Google Sheets

OLX Google Sheets Integration

Connect OLX with Google Sheets through Perno. Turn incoming information into reliable, automated actions without repetitive work.

Allegro → Google Sheets

Allegro Google Sheets Integration

Connect Allegro with Google Sheets through Perno. Turn incoming information into reliable, automated actions without repetitive work.