Tired of manually scouring the web for articles related to your keywords? Frustrated with the hassle of copying, pasting, and organizing information in your Google Sheet? We've got your back.
This automation steps in to save you from the tedious legwork. It will swiftly fetch articles for your keywords, complete with descriptions, links, and titles, and neatly populate your spreadsheet with a new row for each one it finds.
Whether you're a content curator seeking to stay updated or a researcher compiling resources, this automation is your ticket to efficiency. No more endless scrolling, copying, or formatting.
Let’s set it up!
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 tab of your Google Sheet. In this case, it is “Search URL” and “Sheet1”. Bardeen will also ask you to specify how many results you would like to get for each row.
After choosing the spreadsheet, columns, and links, click on “Save Input” and checkmark Google Sheets. You can edit Inputs later by hovering over the playbook.
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 update each row with the results and include information 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.
This playbook saves me 60-90 minutes that I'd spend copy-pasting 20 new jobs details from LinkedIn daily - now it only takes me 5 minutes. Gamechanger!