Try these playbooks:
1⃣ Get SERP for a list of keywords in Google Sheets:
https://www.bardeen.ai/sharedplayboo...
2⃣ Get SERP in Sheets (Cell):
https://bardeen.ai/s/dyxRQGFKaCwf
3⃣ Find search intent from a Google Search page:
https://www.bardeen.ai/sharedplayboo...
4⃣ Get web page content added into a Google Sheet:
https://www.bardeen.ai/sharedplayboo...

✍ PROMPTS and Expressions:

=HYPERLINK("https: //www.google.com/search?q=" & SUBSTITUTE(A2," ", “+"))

=gpt(CONCATENATE(
"Classify the following Google SERP results into the following 4 categories.
Navigational: Users want to find a specific page (e.g., ‘reddit login’)
Informational: Users want to learn more about something (e.g., ‘what is seo’)
Commercial: Users want to do research before making a purchase decision (e.g., ‘best coffee maker)
Transactional: Users want to complete a specific action, usually a purchase (e.g., ‘buy subaru forester’).

Output just the class (like 'Navigational').
Here is the data to analyze: ' "


=gpt (CONCATENATE ("Summarize the following text as bullet points. 10 max. ",


=IF(LEN(TRIM(A1)) = 0, 0, LEN(TRIM(A1)) LEN(SUBSTITUTE(A1, " ", "")) + 1)



Scraper Tutorial:    • The Ultimate Scraper Tutorial | Extra...  

Using AI inside Google Sheets:    • How to Use ChatGPT in Google Sheets (...  

Track website changes:    • How To Monitor Website Changes in 202...  

Download Bardeen: https://bardeen.ai/support/download

Explore Playbooks
https://www.bardeen.ai/exploreplaybooks

Video Chapters:
00:00 Intro
01:25 Scraping SERP
04:12 Classifying search intent
07:51 Creating AI summaries
9:39 End notes

About Bardeen
Bardeen is a productivity app that automates your manual tasks with shortcuts. Follow our channel to learn about the latest tips about automating your daytoday workflows and staying productive as a knowledge worker.

  / bardeenai  
  / bardeenai  
ℹ Need help? Join our Slack community
https://bardeen.ai/community

Popular Automations
Meetings: https://www.bardeen.ai/posts/bestmee...
Scraper: https://www.bardeen.ai/tutorials/scraper