Airtable
OpenAI
Scraper
Workflow Template

Find search intent from a Google Search page and save to Airtable

This playbook will find search intent from the Google search results page and classify the results as commercial, informational, commercial investigation, and transactional. It will then save the results to a specified Airtable.
Bardeen automates your repetitive tasks without code.
Install the Chrome extension for free.
Scrape data on active tab
Action
Get rows of a table
Action
Classify text
Action
Get current page as HTML
Action
Add data to Airtable
Action

How does this automation work?

Understanding search intent is critical for SEO and content strategy. Bardeen’s workflow automation tool enables you to classify the intent of Google Search results and store them in Airtable for analysis. By categorizing search results into commercial, informational, commercial investigation, and transactional, you can better align your content with what your audience is seeking, leading to improved search engine rankings and user engagement.

Here is how this workflow processes Google Search results and saves them to Airtable:

  • Step 1: Scrape Google Search Results - The Scraper extracts data from the active tab where a Google Search has been made, capturing the top 10 search results using a predefined template.
  • Step 2: Extract Data Rows - Bardeen retrieves the rows of data from the table created in the previous step, preparing them for classification.
  • Step 3: Classify Search Intent - Utilizing OpenAI, the text from the search results is classified into categories like commercial or informational, providing insights into user intent.
  • Step 4: Capture Current Page HTML - The HTML content of the current page is captured for any additional context needed for the classification.
  • Step 5: Save to Airtable - The classified data along with the search results are added to a specified Airtable, allowing for organized storage and further analysis.
Run this Airtable automation with Bardeen in minutes.

How to run the workflow

Managing the labyrinthine maze of Google search results can be a daunting task. Whether you're a seasoned marketer, a dedicated researcher, or a strategic business mind, the challenge remains constant: deciphering search intent amid a sea of digital noise.

Bid adieu to the hours wasted sifting through countless pages, struggling to differentiate commercial gold from informational gems. This ingenious automation comes to your rescue. With its remarkable capabilities, it effortlessly classifies search results into distinct categories: commercial, informational, commercial investigation, or transactional.

Seamlessly sync these categorized results directly into your specified Airtable, revolutionizing your data management process. No more tedious copy-pasting; just streamlined, efficient results. 

Let’s set it up!

Step 1: Create an Airtable

The first step is to create an Airtable with the fields you want to save.

Bardeen will extract information from the currently opened search results page and save information like name, classification, classification explanation, link and description.

Step 2: Install the extension and map the information to Airtable

You will be redirected to install the browser extension when you run it for the first time. Bardeen will also prompt you to integrate Airtable.

Click the “Pin it” button at the top of this page to get this automation saved to your Playbooks.

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. 

You will be asked to specify an Airtable. After you choose the database, you will get a prompt to map the information to the fields in Airtable.

The left side consists of all the fields Bardeen will scrape for you. On the right side, specify the fields in Airtable that you want to associate with the information on the left. If you don’t want a piece of information, leave that field empty, and it will be skipped. That’s it!

Click on “Save Input” and checkmark Airtable. You can edit Inputs later by hovering over the playbook. 

Step 3: Run the playbook to find search intent from Google Search and save to Airtable

To get search intent from the Google search results page, navigate to the results page.

Activate Bardeen (or hit Option + B on Mac or ALT + B on PC on your keyboard) and run this playbook. It will get the results and use a classifier to classify the content as commercial, informational, commercial investigation, and transactional.

This automation is fantastic for content creators and digital marketers who can employ this automation to enhance their content strategies. By classifying Google search results into categories like commercial, informational, or transactional, they can gain valuable insights into user intent and tailor their content to better meet the needs of their target audience. This ensures that the content created aligns with what users are searching for, leading to higher engagement and conversion rates.

Sales and business development professionals can use this automation to identify potential leads and prospects. By categorizing search results as commercial investigation, they can pinpoint individuals or organizations actively researching products or services in their industry. This enables more targeted outreach and lead generation efforts, improving the chances of converting prospects into customers.

Market researchers and competitive analysts can also leverage this automation to streamline their processes. It helps them quickly assess the search intent behind specific keywords or topics and categorize search results accordingly. This provides valuable insights into market trends and competitor strategies, allowing businesses to make more informed decisions and stay ahead of the competition.

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

Find more Airtable and Google Search integrations.

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

Run this Airtable automation with Bardeen in minutes.

Available actions & triggers

Apps:
Find search intent from a Google Search page and save to Airtable
Find search intent from a Google Search page and save to Airtable
Find search intent from a Google Search page and save to Airtable
Types:
Both
Actions
Triggers
Extract keywords from text
Extract keywords from text
Action
Add data to Airtable
Add data to Airtable
Action
Take action following defined goal
Take action following defined goal
Action
When website data changes
When website data changes
Trigger
Delete Scraper template
Delete Scraper template
Action
Get saved templates
Get saved templates
Action
Generate email from prompt
Generate email from prompt
Action
Generate example schedule
Generate example schedule
Action
Generate recruiting email
Generate recruiting email
Action
Extract tasks from description
Extract tasks from description
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

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.