Get SERP for a list of keywords in Google Sheets

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.

‍