Google Sheets
Scraper
playbook Template

Get SERP for a list of keywords in Google Sheets

This playbook will get articles for your keywords in a Google Sheet. It will then save the articles along with their descriptions, links and titles into a new tab

This is a Bardeen playbook. It's a pre-built automation template you can run in one-click to perform a repetitive task. Get started with our free Chrome extension.

Explore other automations
This playbook has been deprecated.
Explore Bardeen's playbook catalog for other automations or build your own.

How does this automation work?

Get table from Google Sheet
Action
Get column from table
Action
Scrape data in the background
Action
Get column from table
Action
Create new spreadsheet tab
Action
Add data to sheet tab
Action

Bardeen's "Get SERP for a list of keywords in Google Sheets" playbook is designed to automate SEO research for your team. By using this playbook, you will be able to compile a list of articles related to your keywords and store their descriptions, links, and titles in a Google Sheet. This will save your team time on manual SEO research and help you focus on creating content that ranks.

Here is how this workflow works:

  1. Get table from Google Sheet - Bardeen first reads the content of your Google Sheet, which contains your keywords. This is done using the Google Sheets integration, which allows you to manipulate and extract data from your Google Sheets.
  2. Get column from table - Bardeen then extracts the column from the table that contains the Google Search Links for your keywords.
  3. Scrape data in the background - Using the Scraper integration, Bardeen visits each of the Google Search Links and extracts data from them. The Scraper integration is capable of extracting data from almost any website, and in this case, it will be used to extract data related to your keywords.
  4. Get column from table - Bardeen extracts the column from the table that contains your keywords.
  5. Create new spreadsheet tab - A new tab is created in your Google Sheet to store the extracted data. The tab will be titled with the keyword used for the search.
  6. Add data to sheet tab - Finally, the extracted data is added to the new tab in your Google Sheet. This means you will have a new tab in your Google Sheet for each keyword, containing all the extracted data related to that keyword.

This playbook is most useful for those in the personal productivity category who are looking to automate their SEO research process.

Run this Google Sheets automation with Bardeen in minutes.

How to run the playbook

Are you tired of the time-consuming process of gathering articles for your keywords? Whether you're a content creator, researcher, or simply someone trying to stay informed, the struggle is real. Manually scouring the web for relevant articles and organizing them can be a daunting task.

Enter this efficient automation. It's your trusty sidekick in simplifying this process. With a few clicks, it fetches articles related to your keywords and neatly compiles them in a Google Sheet. You won't need to laboriously copy and paste titles, links, or descriptions anymore.

Picture the convenience of having a dedicated tab filled with articles, ready for your perusal or further analysis. For content creators seeking inspiration, researchers looking to gather sources, or anyone aiming to stay updated, this automation streamlines the way you curate information, making your work more efficient and hassle-free.

Let’s set it up!

Step 1: Pin the playbook and integrate Google Sheets

First, click the “Pin it” button at the top of this page to save this automation. You will be redirected to install the browser extension when you run it for the first time. Bardeen will also prompt you to integrate Google Sheets.

Activate Bardeen (or hit Option + B on Mac or ALT + B on PC on your keyboard) and click on the playbook card. The setup flow will start. Bardeen will ask you for the Google Sheets spreadsheet that contains the SEO content and search links.

Bardeen will also ask you to specify the column that contains the links and the keyword column. In this case, it is “Search URL” and “Keyword”.

After choosing the spreadsheet and columns, click on “Save Input” and checkmark Google Sheets. You can edit Inputs later by hovering over the playbook. 

Step 2: Run the playbook to get SERP for a list of keywords in Google Sheets

Press Option + B on Mac or ALT + B on PC on your keyboard to launch Bardeen. Click on the playbook card and run the playbook to get SERP results to your Google Sheet for each row. It will create a tab with the results for each row and include the results from the search page like name, link and description.

You can also edit the playbook and add your next action to further customize the automation.

You can also find more about how to increase your personal productivity.

Run this Google Sheets automation with Bardeen in minutes.

Available actions & triggers

Apps:
Get SERP for a list of keywords in Google Sheets
Get SERP for a list of keywords in Google Sheets
Get SERP for a list of keywords in Google Sheets
Types:
Both
Actions
Triggers
Get saved templates
Get saved templates
Action
Clear Google Sheet
Clear Google Sheet
Action
Create Google Sheet
Create Google Sheet
Action
Scrape data from multiple pages
Scrape data from multiple pages
Action
When row changes
When row changes
Trigger
Scrape data from HTML file
Scrape data from HTML file
Action
When new row is appended or changed
When new row is appended or changed
Action
Edit current page template
Edit current page template
Action
When website data changes
When website data changes
Trigger
Update or add rows in/to a tab
Update or add rows in/to a tab
Action
how does bardeen work?

Your proactive teammate — doing the busywork to save you time

Integrate your apps and websites

Use data and events in one app to automate another. Bardeen supports an increasing library of powerful integrations.

Perform tasks & actions

Bardeen completes tasks in apps and websites you use for work, so you don't have to - filling forms, sending messages, or even crafting detailed reports.

Combine it all to create workflows

Workflows are a series of actions triggered by you or a change in a connected app. They automate repetitive tasks you normally perform manually - saving you time.

get bardeen

Don't just connect your apps, automate them.

200,000+ users and counting use Bardeen to eliminate repetitive tasks

Effortless setup
AI powered workflows
Free to use
The #1 AI Automation Extension for Chrome

FAQs

What if I don’t use a CRM for the technical handoff?

You can still run the playbook using email, task, and communication tools.

Can I customize the technical handoff report format?

Yes, you can choose where the report is saved or sent.

Is this lead management playbook useful for RevOps teams?

Yes, it helps RevOps teams keep lead data clean, track qualification, and ensure follow-up happens consistently.

Can I use this lead management playbook with LinkedIn Sales Navigator?

Yes, Bardeen can enrich leads using LinkedIn Sales Navigator.

How does this price monitoring playbook help with lead qualification?

Knowing how your pricing compares to competitors can help you qualify sales leads based on budget fit.

Does this daily/weekly report with lead qualification?

Yes. By analyzing call notes and CRM updates, Bardeen can surface which leads are progressing and which need more attention.

By clicking “Accept”, you agree to the storing of cookies. View our Privacy Policy for more information.