Integrations / Google Sheets
Send UK planning applications to Google Sheets
Log every new matching application as a spreadsheet row, or pull a one-off export.
Plota brings UK planning applications from hundreds of council planning portals into one classified, source-linked feed. Connect it to Google Sheets and every new planning application that matches your saved area and categories arrives in Google Sheets automatically - so your team can act on local planning activity the day it is published, without checking council portals by hand.
Before you start
- Get an API key (a free demo key works for testing).
- Create a saved alert in Plota for the area and categories you want, and note its alert id.
How to connect Plota to Google Sheets
Option A - live, via Zapier/Make
Register a Plota webhook (see the Zapier guide), then add the Google Sheets → Create Spreadsheet Row action and map the fields.
Option B - one-off export
Download any saved alert as CSV and File → Import into Sheets:
curl "https://api.plota.co.uk/v1/alerts/123/matches?format=csv" -H "Authorization: Bearer plota_live_your_key" -o matches.csvVerify deliveries
Each webhook is signed - verify the Plota-Signature header (HMAC-SHA256 over timestamp.body). Full details in the API docs.
Google Sheets integration FAQ
Can I send UK planning applications to Google Sheets?
Yes. When a new application matches a saved Plota alert, Plota fires a signed webhook that reaches Google Sheets through Zapier or Make. Each record includes the planning reference, authority, address, description, classified category, dates, and links to the official council source and the Plota page.
Do I need to write code to connect Plota to Google Sheets?
No. You wire Plota's webhook into Google Sheets through Zapier or Make, then map the planning application fields - no code required.
What planning data comes through to Google Sheets?
Every event carries the application reference, authority, address, postcode, description, Plota's classified category, status, received / validated / decision dates, coordinates, the Plota page URL and the official council source URL.
How current is the planning data?
Plota checks UK council planning portals daily and classifies new applications, so matches reach Google Sheets as they are processed - not on a manual schedule.
Is the Google Sheets integration free?
You can test the API with a free demo key. Live webhook delivery into Google Sheets is available on the Starter plan and above; Plota's public planning search and email alerts stay free.