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
When new row is appended
When new row is appended
Trigger
Edit current page template
Edit current page template
Action
Create new spreadsheet tab
Create new spreadsheet tab
Action
When row is added to or changed in Google Sheet
When row is added to or changed in Google Sheet
Trigger
Scrape data from multiple pages
Scrape data from multiple pages
Action
Delete Scraper template
Delete Scraper 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
Add data to sheet tab
Add data to sheet tab
Action
Add text to Google Sheet
Add text to Google Sheet
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

Bardeen - Playbook / Autobooks: Is it possible to create a Playbook that scrapes data from a website and sends it as an email attachment?

You can create a Bardeen Playbook to scrape data from a website and then send that data as an email attachment.

Youtube: Can I download a Youtube video to my computer using Bardeen?

Unfortunately, Bardeen is not able to download videos to your computer.

Google Sheets: What is the best way to export data to Google Sheets?

Exporting data (ex: scraped data or app data) from Bardeen to Google Sheets is possible with our action to “Add Rows to Google Sheets”.

Meetings: Is there a playbook to record and summarize meetings?

There isn't a specific AI use case available for automatically recording and summarizing meetings at the moment

Playbooks/Autobooks: How do I edit an action in a Playbook or Autobook?

Please follow the following steps to edit an action in a Playbook or Autobook.

Scraper: How can I get data from multiple sections of a profile (Eg: getting the experience section on a linkedin profile)?

Cases like this require you to scrape the links to the sections and use the background scraper to get details from every section.

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