Skip to content
ClickRuntime

Connect Google Sheets to Perplexity

Perplexity answers questions with current information and sources; a sheet keeps the questions and the answers in order. Connecting them turns a list of leads, topics or questions into research you can sort, filter and build on, with a dated record of what was found.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Google Sheets and Perplexity

Research for the leads, topics and questions in your sheet, written back next to each row. These are ready-made starting points. Anything else you can describe works too.
Daily

Get a sourced daily news digest, saved to a sheet

Each morning Perplexity researches the latest news on your topic; you get the digest by email and every day is logged in your sheet.

See how it works
Every 15 minutes

Research each new lead in your sheet

Every new prospect row gets a short profile of the person and company and a personal opening line, written back into the sheet.

See how it works
Every 30 minutesAI

Turn topics in a sheet into researched video scripts

Each new topic in your sheet is researched and a 30-second video script is written in the next column, ready to record.

See how it works
DailyAI

Draft a researched LinkedIn post each morning from your topic list

Each morning the next topic in your sheet is researched and turned into a LinkedIn post draft, saved in the sheet for you to edit and post.

See how it works
Every 30 min or scheduleAI

Write researched blog drafts for topics marked ready

Each topic you mark ready in your sheet becomes a researched blog draft, saved back to the sheet with its sources.

See how it works
Weekly

Check each week whether AI search answers mention your brand

Each week your key buyer questions are put to Perplexity, and your sheet records whether your brand was mentioned, how, and which sources were cited.

See how it works Your own logic

Any other automation you can describe in words

Your own rules, schedule and AI steps with Google Sheets and Perplexity, plus any other app. Describe it and your assistant builds it.

See how to build your own

Build your own

Build any Google Sheets and Perplexity automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Google Sheets and Perplexity in your own words, with your conditions, other apps or an AI step, and your assistant writes it, tests it and runs it on ClickRuntime.

  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

For example, ask your assistant

Only research rows where "status" is new, and keep each answer under 120 words with at least two sources.

Each week, re-research companies whose last update is older than 30 days and mark what changed.

Use cases

Why people connect Google Sheets and Perplexity

How the two apps work together

  • A check every few minutes finds new rows, or a daily schedule runs the research.
  • The script sends a question to Perplexity built from the row's columns.
  • It writes the answer and source links back to the row.

  • Analysts researching companies in bulk

    A list of companies gets a short researched profile per row with sources. Research takes minutes.

  • Content teams gathering facts

    Topics in a sheet get current facts and citations. Writers start with sources.

  • Investors tracking news

    A daily row of news per portfolio company is added. Updates are in one place.

  • Sales teams preparing for calls

    Each prospect row gets recent company news. Calls start informed.

More apps

Google Sheets, Perplexity and other apps in one automation

An automation isn't limited to two apps. Add the next step in another app and it runs as part of the same automation.

Share research

After a row is researched, post the summary and sources to #research.

Daily digest

Each morning, research the topics in my sheet with Perplexity and email me the answers.

Enrich deals

For each company in my sheet, research it with Perplexity and add the summary as a HubSpot note on the company.

Setup

Connect Google Sheets and Perplexity once

Every idea on this page uses the same two connections, so you set them up once. If one is missing, your assistant tells you and links to the right place.

Google Sheets

Spreadsheets

  1. In the ClickRuntime dashboard, open Connections and choose Google Sheets.
  2. Sign in with your Google account and allow access.
  3. Pick the spreadsheets the automation may use. It can't see any other file in your Drive.

Perplexity

AI / Search LLM

  1. Open the Perplexity API Portal at console.perplexity.ai and choose the project that should pay for the calls.
  2. Go to API Keys and generate a new key. It starts with pplx-.
  3. In the ClickRuntime dashboard, open Connections & secrets and save the key as a secret for Perplexity.

FAQ

Questions about connecting Google Sheets and Perplexity

Do I need a Perplexity account?
Yes. Save your Perplexity API key in your ClickRuntime dashboard. Each question uses credits from your Perplexity API plan.
Are sources included?
Yes. Perplexity returns the pages it used, and the automations keep those links in the sheet so you can check the facts.
Will it research the same row twice?
No. Rows that already have a result are skipped, so you only pay for new research.
How current is the information?
Perplexity searches the web when asked, so answers reflect what is published at the time of the run.
Which Perplexity model does it use?
The script calls the Perplexity API model you choose, such as sonar.
Does it cost per row?
Perplexity charges per API request and tokens. ClickRuntime does not add a fee.
Can it write to separate columns?
Yes. Ask for structured answers and it fills each column.

Related pages

Keep exploring

Tell your assistant what Google Sheets and Perplexity should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude