Help Centre / Google Sheets

Google Sheets

Export contacts to a spreadsheet, import a spreadsheet as contacts, and add rows from automations.

Connect a Google account once, then:

  • export your contacts to a spreadsheet (once, or kept up to date every 15 minutes);
  • import a spreadsheet tab as contacts (once, or bring in new rows every 15 minutes — handy for Google Forms answers);
  • add a “Add a row to Google Sheets” step to an automation.

Only Owners and Admins can connect Google, in Integrations → Google Sheets.

Overview

You want to…Use
Share your contact list with someone who works in spreadsheetsExport with Keep it updated
Bring leads collected in a Google Form or a team sheet into PALMSImport with Keep importing new rows
Log every new order, booking or lead in a sheet as it happensThe automation step

Connect Google

Before you start: a Google account (Gmail or Google Workspace) that can open the spreadsheets you want to use.

  1. Open Integrations → Google Sheets and click Continue with Google.
  2. Sign in on Google’s page and choose the account.
  3. Google asks to let PALMS “See, edit, create and delete only the specific Google Drive files you use with this app”. Click Continue.
  4. You come back to PALMS and the account shows Connected.

PALMS never sees your Google password. You can connect several Google accounts and disconnect any of them at any time.

Export contacts

  1. Click Export….
  2. Choose A new spreadsheet (PALMS creates it in your Drive) or A tab of an existing spreadsheet (pick it in Google’s window; the tab is replaced or created).
  3. Optionally keep only contacts with a tag.
  4. Tick Keep it updated to rewrite the tab every 15 minutes with your latest contacts.
  5. Click Export, then Open the spreadsheet.

The columns are: Name, First name, Last name, Phone, Email, Language, Country, Stage, Tags, Owner, Source, your custom fields, Created, Updated and PALMS ID. Values are written as plain text, so a name starting with = stays text and is never run as a formula. Up to 50,000 contacts.

Import contacts

  1. Make sure the first row of the tab holds the column titles (Name, Phone, Email…).
  2. Click Import…, then Choose a spreadsheet and pick it in Google’s window.
  3. Choose the tab; PALMS shows the first rows.
  4. Tick Keep importing new rows if new rows will keep arriving (a Google Form, a team sheet).
  5. Click Continue: match columns. You are now in the usual import wizard: match the columns, check the rows, import. You get the same report, and you can undo the import.

Keep importing or exporting

Scheduled exports and imports are listed under Scheduled exports and imports:

  • an import waits until you finish its first import (“Finish the first import”), then brings in only the new rows added at the bottom, with the same columns and options, every 15 minutes;
  • an export rewrites its tab every 15 minutes;
  • Run now, Pause, Resume and Remove are available on each one.

If something goes wrong (the spreadsheet was deleted, the access was removed, someone renamed the columns), the schedule stops with the reason and the person who created it gets a notification. Fix the cause and click Resume.

Automation step

In an automation, add Integrations → Add a row to Google Sheets:

  1. Choose the spreadsheet and the tab.
  2. Add columns: a column title and its value, with variables such as {{contact.name}} or {{contact.phone}}. Use the sheet’s column titles fills them from row 1. Missing titles are added to row 1.
  3. Choose Add a new row or Update the matching row, or add one (matched on a column such as the phone number).

Test it with Test run: nothing is written during a test run.

Permissions and privacy

PALMS asks Google only for the drive.file permission: it can open the spreadsheets it creates and the ones you choose in Google’s picker, and nothing else in your Drive. Google tokens are stored encrypted. Disconnect removes PALMS’ access immediately at Google, stops the schedules and keeps your files.

Troubleshooting

MessageWhat it meansWhat to do
“Signing in with Google isn’t switched on for PALMS yet”The server has no Google sign-in keys.Ask your PALMS administrator (see docs/INTEGRATIONS.md).
“You cancelled on Google’s page”You closed or refused the Google screen.Click Continue with Google again and allow access.
“PALMS needs access to specific Google Drive files…”The permission box was unticked.Connect again and leave the box ticked.
“Google refused the saved sign-in” / Sign in againThe Google password changed, or access was removed in your Google account.Click Reconnect.
“This spreadsheet was deleted or PALMS can’t open it”The file is in the bin, or it was never chosen with this Google account.Restore it, or choose it again in Google’s window.
“The tab … doesn’t exist”The tab was renamed or deleted.Rename it back, or remove the schedule and create a new one.
“Someone changed the column titles in row 1”A scheduled import stopped so it doesn’t fill the wrong fields.Put the titles back, or start a new import.
“Google is limiting requests”Too many requests in a short time.Nothing: PALMS tries again at the next run.

Still stuck?

Our team answers on WhatsApp, in English or French.

WhatsAppOpen Graphwafe