Connect Google Sheets

With Google Sheets connected, each sale event becomes a row in a spreadsheet of yours: PIX generated (PIX is Brazil's instant payment), order paid, decline, shipment, subscription, abandoned checkout. The spreadsheet receives data that only Vipter has, such as phone, tax ID, address and UTMs, and helps you check sales, build your own reports or feed other tools.

The connection is made through a Google Apps Script that you paste into the spreadsheet and deploy on your account. Vipter does not ask for a Google sign-in and has no access to your Drive: it only calls the script's address with a secret that both of you know.

Before you start, read how automations work.

How the spreadsheet looksCopy Anchor Link

• One tab per event, named after it: PIX gerado, Pedido pago, Checkout abandonado and so on. To write everything to a single tab, fill in SINGLE_SHEET in the script (step 2). In that case, the evento column tells the rows apart.
• Automatic header: the first row of an empty tab gets the field names of the sale record. A new field becomes a new column at the end. Columns you move or add by hand stay where they are.
• No duplicate rows: an event that arrives again, in a retry or a resend, is not written twice. The script checks the id_evento column.
• Cells ready to use: dates become real dates. The PIX code, the postal code (CEP) and a phone with + stay as text, so Sheets does not turn them into numbers. A text that starts with =, +, - or @, such as a name typed that way on purpose, also stays as text and never becomes a formula.

Step 1: copy the script in VipterCopy Anchor Link

1. In the Vipter dashboard, open General›Integrations›Automations›Google Sheets.
2. Under Spreadsheet script, click Copy script. You see Script copied.

If the browser does not allow copying, the dashboard selects the script so you can copy it with Ctrl+C or ⌘C.

Step 2: paste the script into the spreadsheetCopy Anchor Link

1. Open the spreadsheet in Google Sheets and go to Extensions›Apps Script.
2. Delete the editor's content and paste the script.
3. On the line var SECRET = 'COLE_AQUI_O_SEGREDO';, replace COLE_AQUI_O_SEGREDO with a long, random password of 30 characters or more. Keep this password for step 4.
4. Optional: to write everything to a single tab, change var SINGLE_SHEET = ''; to a name, such as var SINGLE_SHEET = 'Vendas';.
5. Save the project.

Step 3: deploy as a web appCopy Anchor Link

1. In Apps Script, click Deploy›New deployment.
2. Under Select type, choose Web app.
3. Under Execute as, choose Me. Under Who has access, choose Anyone.
4. Click Deploy and authorize access with your Google account. If Google warns that the app is not verified, it is your own script: open Advanced and continue.
5. Copy the Web app URL. It ends in /exec.

To check that the deployment is live, open the URL in your browser. The response is {"ok":true,"vipter":true}, with no data from the spreadsheet.

Step 4: connect in VipterCopy Anchor Link

1. Back in Vipter, under Connection, fill in the numbered fields.

2. Under Events sent, uncheck what you don't want in the spreadsheet.
3. Leave Active — send events to this platform on and click Save.
4. Click Test connection. The script checks the secret and answers without writing anything to the spreadsheet.

Change the script or the secret laterCopy Anchor Link

• You edited the script: publish a new version in Deploy›Manage deployments, using the edit pencil, with Version: New version. Without this, the old version keeps running. The URL does not change.
• You created another deployment: a new deployment has a different URL. Paste the new URL into Vipter and save.
• You changed the secret: change it in the script, publish a new version and save the same password in Vipter. While the two are different, events fail with invalid_secret.

Deliveries, retries and resendCopy Anchor Link

• sent: the row was written, or it already existed.
• failed: the script rejected it or Google did not answer. When the spreadsheet is busy or Sheets returns an error, Vipter tries again on its own after 5 minutes, 30 minutes, 2 hours, 6 hours and 24 hours. A wrong secret and a misconfigured deployment are not retried: fix the cause and use Resend.

Resending is safe: the row is only written if it is not in the tab yet. See retries and resend.

Common problemsCopy Anchor Link

• The delivery failed with "the Apps Script did not answer JSON"

  The deployment is not set to Anyone, or the URL is not the one ending in /exec. Google answered with the sign-in page instead of the script. Check step 3 and paste the /exec URL.

• The delivery failed with "Apps Script: invalid_secret"

  The password in Vipter is different from the one in the script, or the script was edited without publishing a new version. Check both sides.

• The delivery failed with "Apps Script: secret_not_configured"

  The script still has COLE_AQUI_O_SEGREDO. Replace it with the password, save and publish a new version.

• A new column showed up at the end of the tab

  Vipter started sending a new field. Fields never change their names or disappear, so the columns you already use stay correct.

What to do nextCopy Anchor Link

• See what each column means in the sale record.
• To receive the events in your own system, with signatures and retries, use webhooks.