SerpApi, LLC
SerpApi, LLC
  • Видео 79
  • Просмотров 150 725
Scrape Google with No Code Make.com and Google Sheets
Discover how to scrape Google Search results with Make.com's no code platform and send the results to Google Sheets.
0:00 Introduction
0:27 Google Sheets setup to update rows
1:47 Add SerpApi Google Search
2:41 Update rows in Google Sheets
3:51 Google Sheets setup to add rows
4:11 Iterate over SerpApi Google Search results
5:00 Add rows to Google Sheets
Просмотров: 456

Видео

Scrape Google Flights with simple API
Просмотров 591Месяц назад
Let's see how to scrape flight information from the Google Flights website. We'll use a simple API from SerpApi: serpapi.com/google-flights-api. 00:00 Intro 00:09 Google Flights API doc 00:50 Playground 00:55 Coding time! 02:50 Print all flight information 04:37 Return flight information
Scrape Yelp Reviews using Python
Просмотров 2122 месяца назад
Learn how to scrape place reviews from Yelp using a simple API by SerpApi. We can filter and sort the reviews. Once you have this data, you can do anything you want with it, including exporting the results to CSV or an Excel file. Watch "How to scrape Yelp places": ruclips.net/video/HA0YbUuAnaU/видео.html API Documentation: serpapi.com/yelp-reviews-api Chapters 00:00 Intro 00:13 Yelp Reviews AP...
Make amazing Job Board Posts using SerpApi
Просмотров 3313 месяца назад
Nowadays it's very important to have an online presence and promote your work in creative ways. However, creating content is not easy, especially when you need to be consistent in order to stay relevant. It's important that creating content doesn't become a burden, so a good strategy for creating content in a sustainable way is to choose a specific niche you enjoy to focus on, and find content ...
Google rank checker tool (Excel to Excel)
Просмотров 8193 месяца назад
Do you need to monitor the ranking for multiple domains using multiple keywords? Don't worry! It's now very easy to check the ranking of your (or your client's) websites. Just upload the list of keywords and domains you want to monitor, and we'll export it back to you with the ranking position and matches link. Website: nocodeserpapi.com/app/bulk-google-rank-checker Get your API Key here: serpa...
Scrape Yelp - business data - using API with Python
Просмотров 5784 месяца назад
Simple Yelp Data Scraping with SerpApi: Step-by-Step Guide! In this video, I'll show you how to scrape business information from Yelp without building your own scraper by using SerpApi. We'll start with the Yelp Search API to retrieve business search results and then use the Yelp Place API to get detailed information on each business. I'll guide you through setting up a Python script using the ...
Scrape stock price data with Python
Просмотров 4944 месяца назад
How to Scrape Stock Prices and Market Trends using Python In this tutorial, we'll learn how to scrape stock prices using Python. We will start by setting up your API key from SERP API and installing necessary packages like python-dotenv and the SERP API library. We’ll guide you through scripting to request stock data and market trends from Google Finance, using the SERP API client to filter res...
Web scraping and parsing with AI models (Gemini, Claude & OpenAI)
Просмотров 1,1 тыс.4 месяца назад
Comparing AI Models for Parsing HTML to JSON: Gemini, OpenAI, and Cloud In this video, I experimented with which AI model is best for converting raw HTML data into structured JSON. We test three models: Gemini, OpenAI, and Cloud by Anthropic. While Groq couldn't be included due to token limitations, we demonstrated the process using local HTML files and a helper function. After running tests on...
OpenAI Structured Outputs Tutorial (Parse data string to beautiful JSON)
Просмотров 5784 месяца назад
Extracting Structured Data with OpenAI's New Feature Using Node.js In this video, we demonstrate how to use OpenAI’s new Structured Outputs feature to easily transform user input or raw HTML into structured JSON data. This feature is more straightforward than function calling and guarantees outputs matching the provided JSON schemas. Using Node.js and the Zod library for schema validation, we w...
Connect Gemini API to the internet (Function Calling Tutorial)
Просмотров 2,5 тыс.5 месяцев назад
Learn how to access the internet using Gemini API and SerpApi using Python. Integrating Google Gemini with Google Answer Box for Real-Time Data. In this video, we'll see how to connect Google's Gemini API with the Google Answer Box using function calling. Learn how to create a function to fetch and format real-time answers from Google search results. We'll enhance the capabilities of the Gemini...
Scrape unlimited leads in one click (Collect data from Google Maps)
Просмотров 16 тыс.6 месяцев назад
Wondering how you can scrape business data from Google Maps easily? No coding knowledge required! Now, you can collect addresses, phone numbers, and websites for your lead list from Google Maps in one click! Resource: No Code SerpApi: nocodeserpapi.com/ Get your SerpApi Key here: serpapi.com/ Chapters: 00:00 Intro 00:10 Get API Key 00:30 How to scrape leads data 01:12 Export data to Excel This ...
Groq - Fastest AI with real-time data (using Function Calling)
Просмотров 6326 месяцев назад
Combining Grog AI and Real-Time Internet Data with SERP API. A video tutorial on how to use tool use or function calling with Groq. In this video, we'll demonstrate how to use function calling with Grog AI, the fastest AI inference engine currently available. We'll see the process of integrating real-time internet data, such as current weather or stock prices, into AI-generated responses by uti...
Get real-time data for your AI Voice assistant
Просмотров 7637 месяцев назад
Make sure to watch Part 1 of this video: ruclips.net/video/9-CTSmvNtp0/видео.html AI model has a limitation; the knowledge is cut off by certain years. Don't worry! using the function calling from OpenAI we're able to call 3rd party function, including an external API. We're going to use the Google search answer box API by SerpApi to get real-time data answers from the internet. This way, our v...
Build an AI Voice Assistant using OpenAI tutorial
Просмотров 3,1 тыс.7 месяцев назад
A step-by-step guide on how to build an AI Voice Assistant with OpenAI API and Web Speech API We demonstrate how to build an AI voice assistant using OpenAI and Web Speech API. The tutorial covers setting up the frontend with HTML, CSS, and JavaScript, and the backend using Node.js and Express. I'll walk you through the steps of configuring the Web Speech API for voice input and output, connect...
Is it legal to scrape public pages?
Просмотров 627 месяцев назад
Scraping Public Pages is legal in the US Check out this blog post at: serpapi.com/blog/scraping-public-pages-legality/ This video is about the legality of web scraping in the US. Although this was a once a very grey-area legally, precedents set in many cases, especially recently, lean in favor of scraping public pages. You can learn all about these cases and what this means not only for SerpApi...
Bulk Google Search Result Scraper - Data to Excel (No Code solution)
Просмотров 4588 месяцев назад
Bulk Google Search Result Scraper - Data to Excel (No Code solution)
Google Scholar Scraper - scrape data to Excel (No-code solution)
Просмотров 7618 месяцев назад
Google Scholar Scraper - scrape data to Excel (No-code solution)
Scrape Google Play Store App Reviews 2024 - (Using Python + Simple API)
Просмотров 3 тыс.8 месяцев назад
Scrape Google Play Store App Reviews 2024 - (Using Python Simple API)
Connect OpenAI AI assistant to the internet (NodeJs tutorial)
Просмотров 2,5 тыс.9 месяцев назад
Connect OpenAI AI assistant to the internet (NodeJs tutorial)
OpenAI Assistants API - Code Tutorial (NodeJs)
Просмотров 4,6 тыс.9 месяцев назад
OpenAI Assistants API - Code Tutorial (NodeJs)
Google Shopping scraper - Scrape shopping data to Excel (NoCode)
Просмотров 73210 месяцев назад
Google Shopping scraper - Scrape shopping data to Excel (NoCode)
Google News scraper - Scrape news data to Excel (NoCode)
Просмотров 1,7 тыс.10 месяцев назад
Google News scraper - Scrape news data to Excel (NoCode)
Google Maps Reviews Scraper - Scrape text and ratings data to Excel (NoCode)
Просмотров 1,2 тыс.10 месяцев назад
Google Maps Reviews Scraper - Scrape text and ratings data to Excel (NoCode)
Google Search Results Scraper - scrape SERP data to Excel (No Code Solution 2024)
Просмотров 1,6 тыс.11 месяцев назад
Google Search Results Scraper - scrape SERP data to Excel (No Code Solution 2024)
Google Maps Scraper - Scrape places data to Excel (NoCode)
Просмотров 1,7 тыс.11 месяцев назад
Google Maps Scraper - Scrape places data to Excel (NoCode)
OpenAI Function Calling - Connect AI to the Internet
Просмотров 6 тыс.11 месяцев назад
OpenAI Function Calling - Connect AI to the Internet
Scraping Google Maps using SerpApi and Node.js
Просмотров 641Год назад
Scraping Google Maps using SerpApi and Node.js
Scraping SERP API with Google Sheets (No Code)
Просмотров 2,4 тыс.Год назад
Scraping SERP API with Google Sheets (No Code)
Connect custom GPT to Google (use external API to access internet)
Просмотров 8 тыс.Год назад
Connect custom GPT to Google (use external API to access internet)
Scrape Google Shopping data using Python and simple API
Просмотров 1,1 тыс.Год назад
Scrape Google Shopping data using Python and simple API

Комментарии

  • @jovayutube
    @jovayutube 17 часов назад

    THANK YOU SO MUCH for posting this video. Please, is there a way to use this same method to get TARGETED EMAILS from Facebook Groups? YOU'RE AWESOME! BEST REGARDS!

  • @3170ccp
    @3170ccp 5 дней назад

    good video, waiting for more web scraping videos. thanks

  • @thekenyago
    @thekenyago 6 дней назад

    Do you have the code you used available for download minus the api obviously

  • @anassheikh2657
    @anassheikh2657 10 дней назад

    @serpapi why it's not verifying phone#? It says invalid number

  • @anassheikh2657
    @anassheikh2657 10 дней назад

    @serpapi why it's not verifying phone#? It says invalid number

  • @mujtabamohamed4084
    @mujtabamohamed4084 15 дней назад

    How many results can be obtained for a single query? "I am trying to scrape all the hotels in a particular city, but the retrieved results are limited to a small number, not exceeding 600. How can I overcome this limitation?"

  • @kaluchuxy4537
    @kaluchuxy4537 19 дней назад

    If this is what Google called function calling, they should think again, because this can be achievable just a prompt, eg "you are a helpful assistant your role is check the user query and decide the best tools that matches it, refrain from the explaining anything and just response the tool name only this is the {query} and this is the tools: {tool1{name: search_internet, description :"use this to search internt"}}" SO I DO NOT SEE ANYTHING FANCY here, the ai does not execute instructions but tell yo want to use.

  • @anonymous-l4c
    @anonymous-l4c Месяц назад

    gemini api is very bad from my experience its response is sometimes stupid

  • @SaraAli-ok6xt
    @SaraAli-ok6xt Месяц назад

    Great

  • @KrishnaKumarSharma-uc7sq
    @KrishnaKumarSharma-uc7sq Месяц назад

    1:46 g😅

  • @ishandutta2045
    @ishandutta2045 Месяц назад

    Does AI result also come. I the ones shown on Google search results now a days

  • @CamiloVillotaIbarra
    @CamiloVillotaIbarra Месяц назад

    Hello! Thank you for the clear content-it has been very helpful. However, I’m encountering an issue where the response doesn’t seem to be based on my file. Do I need to configure something additional? On my GUI Assistant, the configuration includes the store and responds correctly, but it doesn’t work when using Node.js.

  • @abdelouahedDeez
    @abdelouahedDeez Месяц назад

    Thanks a lot brother, Do you know any tool To warm up em ails

    • @serpapi
      @serpapi Месяц назад

      I'm sure there are many options out there. Try Google "warm up email tools". I hope it helps.

  • @ГригорийГригорий-и5и
    @ГригорийГригорий-и5и 2 месяца назад

    how to parse the whole news, not just the headline?

    • @serpapi
      @serpapi Месяц назад

      Hi, In order to scrape the entire news, you need to visit the original URL one by one. It's outside of the scope of this tool.

  • @HonestReview101
    @HonestReview101 2 месяца назад

    Why isn't Nigerian phone number accepted

  • @saeedabdolahi8223
    @saeedabdolahi8223 2 месяца назад

    Hi, quick question. Play store says that there are 12.3K reviews for this game. But you were only able to extract around 1.4K reviews. Is there some limitation in scarping all the reviews of an app? (Asking because I need to extract all the reviews rather than a subset of it)

  • @serpapi
    @serpapi 2 месяца назад

    Watch "How to scrape Yelp Reviews" : ruclips.net/video/BIwhGGmWD7I/видео.html

  • @serpapi
    @serpapi 2 месяца назад

    Watch "How to scrape Yelp places": ruclips.net/video/HA0YbUuAnaU/видео.html

  • @emai2iky
    @emai2iky 2 месяца назад

    Hi there, can you suggest how to scrap featured snippets? I tried multiple search queries but none could get the featured snippet (position zero) scrapped! Thank you

    • @serpapi
      @serpapi 2 месяца назад

      Hi, take a look at the sample result here: serpapi.com/playground?q=how+to+make+coffee&location=Austin%2C+Texas%2C+United+States&gl=us&hl=en&google_domain=google.com&newPara=chips+as_sitesearch+highlight+stick+lr+as_qdr+votes+site+safe+google_domain+si+form+filter+as_epq+client+ie+oe+pws+ibp+source+rlz+ijn+interval, You can point the Google Sheets value to where the featured snippet available. In this case, it's located under answer_box, so here is an example to get the title of the featured snippet: `=SERPAPI_RESULT("engine=google&q=how to make coffee&location=Austin, Texas, United States&google_domain=google.com&gl=us&hl=en", "answer_box.title") . You can adjust the title by any key you need.

  • @ikytai8242
    @ikytai8242 2 месяца назад

    Hi there, can you suggest how to scrap featured snippets? I tried multiple search queries but none can get the featured snippet (position zero) results

    • @serpapi
      @serpapi 2 месяца назад

      First, the search must have featured snippets. Remember that Google doesn't always return featured snippet for every searches. Hi, take a look at the sample result here: serpapi.com/playground?q=how+to+make+coffee&location=Austin%2C+Texas%2C+United+States&gl=us&hl=en&google_domain=google.com&newPara=chips+as_sitesearch+highlight+stick+lr+as_qdr+votes+site+safe+google_domain+si+form+filter+as_epq+client+ie+oe+pws+ibp+source+rlz+ijn+interval, You can point the Google Sheets value to where the featured snippet available. In this case, it's located under answer_box, so here is an example to get the title of the featured snippet: `=SERPAPI_RESULT("engine=google&q=how to make coffee&location=Austin, Texas, United States&google_domain=google.com&gl=us&hl=en", "answer_box.title") . You can adjust the title by any key you need.

  • @adarshkotagi5651
    @adarshkotagi5651 2 месяца назад

    Very nice

    • @serpapi
      @serpapi 2 месяца назад

      Thank you for your kind words!

  • @AimeeKisaboyun
    @AimeeKisaboyun 3 месяца назад

    This is BS, it keeps on loging me out.

    • @serpapi
      @serpapi 3 месяца назад

      Hi we're sorry for the issue you're facing. We don't require sign up / login to this tool. Feel free to reach out to us at contact(at)serpapi(dot)com

  • @aarif_zaidi
    @aarif_zaidi 3 месяца назад

    this is good, but it's too costly.

    • @serpapi
      @serpapi 3 месяца назад

      Thank you very much for your comment. Feel free to reach out at contact(at)serpapi(dot)com to discuss your budget.

  • @khanhhq2044
    @khanhhq2044 3 месяца назад

    Can it be done as a conversation (no record, stop). Can you give me the keyword to do that?

    • @serpapi
      @serpapi 3 месяца назад

      sure, you just need to play around with the javascript on the frontend to trigger the recording without a button.

  • @SujithP-y9b
    @SujithP-y9b 3 месяца назад

    hai sir python scrapping in Yelp how do you ? lastest version video update pls sir

    • @serpapi
      @serpapi 3 месяца назад

      Hi, you can follow the step-by-step guide on this video. If you prefer, you can also read our blog here: serpapi.com/blog/how-to-scrape-yelp-data-places-and-reviews/

  • @Web.Scraping
    @Web.Scraping 3 месяца назад

    .. 👍

  • @carsynnmiller397
    @carsynnmiller397 3 месяца назад

    Hi, great video! Would I be able to scrape the citation list of a certain article as well? I am trying to scrape all articles that cite a specific study

    • @serpapi
      @serpapi 3 месяца назад

      Hi, thank you for your question. Right now, this tool only limited in the Scholar Search result. But you can use our "Google Scholar Cite API" to scrape the citation list. Here is the reference: serpapi.com/google-scholar-cite-api

  • @mohammedsaqlainshaikh7029
    @mohammedsaqlainshaikh7029 3 месяца назад

    Hello Really Great and Informative Video.. But are you looking for a video editor I'm currently working with other creators so I'm well aware how to properly editing your niece videos

  • @MerveYücel-n3h
    @MerveYücel-n3h 3 месяца назад

    you are perfect, thank u this amazing information..

    • @serpapi
      @serpapi 3 месяца назад

      Thank you very much for your kind words! please let us know if you need any help.

  • @janakchetri7731
    @janakchetri7731 3 месяца назад

    @serpapi Thanks for this explanation of Google review api data extract. My use case is to extract reviews using power query and then visualize in Power BI. How you would recommend to do that and would this API work well with Power Query?

  • @nhatbang1642
    @nhatbang1642 3 месяца назад

    how to use it with flutter

  • @ihwan_id
    @ihwan_id 3 месяца назад

    thanks for source code. add AI to project is so simple. i guess im ready to build next AI company XD

    • @serpapi
      @serpapi 3 месяца назад

      We're glad to hear that! Please let us know if you need anything else.

  • @Riya-qw1qb
    @Riya-qw1qb 4 месяца назад

    Hi everyone, I recently developed a tool that extracts unlimited business data and emails from Google Maps and supports sending 2000 emails a day. I’ve got a sample of the data if anyone’s curious. Would love to discuss its potential uses or get some feedback!

    • @akinoye
      @akinoye 3 месяца назад

      Can you share the tool with me to try and be able to give you feedback.

  • @melonpip
    @melonpip 4 месяца назад

    Why is serpapi so expensive for the lowest tier? I feel like there should be a personal tier that fits below the $75 tier. 😊

    • @serpapi
      @serpapi 4 месяца назад

      Hi, we're happy to discuss a potential discount depending on your needs. Feel free to contact us at contact(at)serpapi(dot)com.

    • @melonpip
      @melonpip 4 месяца назад

      @@serpapi thanks thats cool 😊

  • @charulatha1725
    @charulatha1725 4 месяца назад

    This is awesome ❤after wasting my half a day..but after extracting this into excel how to do as a project?

    • @serpapi
      @serpapi 4 месяца назад

      Thank you for your comment; I'm glad it helps. Can you please clarify what you mean by "to do as a project?"

  • @charulatha1725
    @charulatha1725 4 месяца назад

    400 Client Error: Bad Request for url. how can i solve this error

    • @serpapi
      @serpapi 4 месяца назад

      Feel free to share more detail at contact(at)serpapi(dot)com. We'll be happy to help!

  • @KashishVarshney-cr7iz
    @KashishVarshney-cr7iz 4 месяца назад

    this is not the correct approach what if query needs parallel function call? In this case, this code will fail execution

    • @serpapi
      @serpapi 4 месяца назад

      Thank you for your comment, feel free to share an implementation for parallel function calling.

  • @ebnisholikhah8003
    @ebnisholikhah8003 4 месяца назад

    I couldn't fine the API key, where the API key actualy?

    • @serpapi
      @serpapi 4 месяца назад

      Hi, your API Key is available on your dashboard. serpapi.com/dashboard

  • @thisauthority
    @thisauthority 4 месяца назад

    Cool. But there's no column for emails and social media handles.

    • @serpapi
      @serpapi 4 месяца назад

      Hi, we can scrape it as long as the information is available on the Google Maps. Can you share a link example from Google Maps where those information available for a place? we'll be happy to investigate it.

  • @fefefefefee32
    @fefefefefee32 4 месяца назад

    i keep getting "Unrecognized request arguments supplied: json_schema, type"

  • @FabioVivaoLinux
    @FabioVivaoLinux 4 месяца назад

    Thank you, very useful video and repository.

    • @serpapi
      @serpapi 4 месяца назад

      Hi Fabio! I'm glad it's helpful! Thank you very much for leaving a comment.

  • @serpapi
    @serpapi 4 месяца назад

    ⚠ Important update: We now use the `sur` parameter instead of `il` to filter the image license. Please refer to our docs: serpapi.com/google-images-api#api-examples-results-for-coffee-with-tbs-il-cl-creative-commons-licenses

  • @serpapi
    @serpapi 5 месяцев назад

    [Update on Pagination] Google Jobs API recently updated its layout. To paginate the results, we need to use next_page_token as parameter instead of the start parameter. You can get the next_page_token value from the initial response. Reference: serpapi.com/google-jobs-api#api-parameters-pagination

  • @ChristopherBruns-o7o
    @ChristopherBruns-o7o 5 месяцев назад

    The alert for when query to Gemini and not having access to information after cut off date - like error signal and the screen flashed red, Very cool idea. +1 I would suggest using send_message instead of generate content with tool call and then using generate content at the end to enable break out loop.

    • @serpapi
      @serpapi 5 месяцев назад

      Thank you very much! I'll look into your suggestion :)

  • @sahilgarg4850
    @sahilgarg4850 5 месяцев назад

    How can we run this code in Google Colab ?

    • @serpapi
      @serpapi 4 месяца назад

      Hi, feel free to read our guide on how to use SerpApi on Google Colab: serpapi.com/blog/using-serpapi-in-google-colab/

  • @RenatinhoLicioniFilho
    @RenatinhoLicioniFilho 5 месяцев назад

    I'm trying to setup a web scraper for facebook marketplace, can you help me with that?

    • @serpapi
      @serpapi 4 месяца назад

      Hi, I apologize for the delayed response. We have a public roadmap where you can put a feature request: github.com/serpapi/public-roadmap. Feel free to add Facebokk marketplace on the list.

    • @jovayutube
      @jovayutube 17 часов назад

      @@serpapi THANK YOU SO MUCH for posting this video. Please, is there a way to use this same method to get TARGETED EMAILS from Facebook Groups? YOU'RE AWESOME! BEST REGARDS!

  • @CruxfromAI
    @CruxfromAI 5 месяцев назад

    Hi, I would like to discuss a project with you. Can you please let me know how do I reach out to you?

  • @ElonSpier
    @ElonSpier 6 месяцев назад

    I got an 401 Client Error: Unauthorized when changing the keyword

    • @sololearn4576
      @sololearn4576 5 месяцев назад

      I didn't got any error at first.. But when i changed q. Then i got the same error

    • @serpapi
      @serpapi 4 месяца назад

      You need to set your API key first. Make sure to register at serpapi.com and add the API key in your env file or export it on your current dir.

  • @njascoey
    @njascoey 6 месяцев назад

    hi, how can i export more data to csv with the pagination?

    • @serpapi
      @serpapi 6 месяцев назад

      Hi, at ~ min: 4:00 instead of printing the count, you can collect all the data in a variable. Then you'll use the same method to print it to a CSV file as in the last chapter. If you have any other questions, feel free to reach us at contact(at)serpapi(dot)com

  • @plm8852
    @plm8852 6 месяцев назад

    • @serpapi
      @serpapi 6 месяцев назад

      We hope it's helpful!