Peter Mangan
Peter Mangan
  • 34
  • 122 690
Scrape Datasets from Websites with AI and Excel
In this video, I'll show you how to use PromptLoop.com to quickly build and deploy a web scraper that can help you learn about your competitors' customers and case studies. We'll take a list of software companies and extract all the case study information from their websites, including the customer names, case study links, and descriptions. This information can be a treasure trove for understanding your market and engaging with prospects.
I'll walk you through the entire process, from setting up the task in PromptLoop to testing and running the scraper on a dataset. You'll see how easy it is to customize the data you want to extract, validate the results, and download the final dataset in CSV format. Everything shown in this video is available on PromptLoop's free plan, so you can follow along and try it out for yourself.
By the end of this short video, you'll know how to:
Set up a web scraping task in PromptLoop
Customize the data fields to extract
Test and validate the scraper results
Run the scraper on a list of competitor websites
Search, filter, and export the final dataset
If you want to gain valuable insights about your market and competitors, this video will show you a quick and easy way to do it using PromptLoop's web scraping capabilities. Let me know if you have any other questions!
www.promptloop.com/account/docs/lists
zhlédnutí: 254

Video

Scrape Names and Emails from Websites in 2 Minutes with AI
zhlédnutí 168Před měsícem
In this video, I'll show you how to quickly and easily create organized datasets from web data using AI-powered web scraping. We'll demonstrate how to use the tool PromptLoop to scrape information like names, addresses, specialties, and phone numbers from multiple websites and compile it into a formatted dataset in just a couple minutes. Whether you need to build lists of restaurants, company d...
How to Build a Web Scraper with AI in Minutes - No Coding Required!
zhlédnutí 814Před 2 měsíci
🚀 Discover how to create a powerful web scraper using AI, without any coding or special knowledge! In this step-by-step guide, we'll show you how to use PromptLoop.com to scrape data from hundreds or thousands of websites effortlessly. 🌐 Whether you need to gather information about companies, prospects, or competitors, our AI-powered scraper can help you turn any list of websites into a valuabl...
Scrape a list of company websites in 30 seconds!
zhlédnutí 406Před 2 měsíci
- Follow along for free www.promptloop.com/ - Try it free here www.promptloop.com/welcome In this video, we demonstrate how to quickly scrape a list of company websites and extract valuable information such as phone numbers, email addresses, and locations using PromptLoop, an AI-powered data enrichment platform. By simply uploading a spreadsheet containing company names, PromptLoop can automati...
Enrich Company Data from a Spreadsheet
zhlédnutí 240Před 3 měsíci
🚀 Unlock the Power of Company Data with Promptloop AI! 📈 Are you tired of manually researching company information for your business development or investment leads? Look no further! In this video, I'll show you how to effortlessly enrich your company data straight from a spreadsheet using Promptloop AI. We are using a list of companies from the PPP dataset. With our cutting-edge technology, yo...
Automatically Label a Spreadsheet with AI - Upload and go
zhlédnutí 355Před 4 měsíci
We are going to learn how to use AI to automatically generate categories and label a dataset - even if it has thousands of rows. Categories and labels are automatically generated for you and it only takes a few minutes to learn. Label Excel or Google Sheets data automatically with AI like chatGPT. Label youtube comments, business types, email chains and more with automatic smart labels.
How to use AI for Web Scraping with Excel and Google Sheets
zhlédnutí 14KPřed 5 měsíci
Discover the power of AI for web scraping in our comprehensive video "How to use AI for Web Scraping with Excel and Google Sheets." We'll be guiding you through the intricacies of utilizing AI like chatGPT Browser to gather data from the web and organize it efficiently in Excel and Google Sheets for analysis and reporting. In this tutorial, we reveal innovative scraping methods enabled by Promp...
AI Web Research for Excel
zhlédnutí 758Před rokem
Have you ever wished you could automate web research? In this video, we will use the AI-powered PromptLoop function to search, scrape and return hundreds of web results in seconds right in Excel. Research markets, competitors, customers, and more with models trained to return exact answers and provide sources and links. Links: www.promptloop.com/demo www.promptloop.com/docs/excel/excel-enable
10x Engagement on LinkedIn with a custom AI content engine
zhlédnutí 431Před rokem
Looking to grow your network, company, or sales? In this video - we walk through how to make a custom AI LinkedIn Content engine with the spreadsheet tool PromptLoop. We include a template (linked) and subscribers can follow along with a free account using the link below: docs.google.com/spreadsheets/d/1x8k6KszpqkIagqdG0-lpOcr7M39iucR-aRO6yABMfOk/template/preview
How to Label Text with AI in Excel in 5 minutes
zhlédnutí 2,3KPřed rokem
In this video, we learn how to use AI in Excel to label text. We take a list of sales data with addresses, emails, and job titles and organize it into buckets using the AI formula PromptLoop. PromptLoop uses models like the ones powering chatGPT and OpenAI to let you work with text in Excel. We end by summarizing in a pivot table. You can follow along and use the link below for a free account! ...
Make a custom AI content engine in five minutes
zhlédnutí 635Před rokem
In this video, we explore how to make a spreadsheet model that can take a few E-commerce descriptions and connect and AI model to generate a description for any new product. We look at the Tiffany-Nike collab and see how well the AI model does! ✅Template available free to use here: docs.google.com/spreadsheets/d/1AxQn2si3K6REtYQI6vCJokNlz5c3HFPszz8ZT2LfNDc/template/preview ✨And more on PromptLo...
Can you write better emails than chatGPT?
zhlédnutí 162Před rokem
In this video we will break down the three most important components of an email. This framework lets you use AI tools to draft customized messages to communicate clearly and get the results you want. Template: www.promptloop.com/templates/email-template-generator
Can you really detect chatGPT outputs?
zhlédnutí 837Před rokem
As more and more of us start using AI writing tools, many people are wondering if its possible to tell human from AI. Well that's exactly what we dive into here using the free www.gpt-detector.com/ and chatGPT. Let's go!
SEO with GPT-3: Optimize Your Website to Rank (PromptLoop Template)
zhlédnutí 2,1KPřed rokem
SEO with GPT-3: Optimize Your Website to Rank (PromptLoop Template)
How to use GPT-3 with Google Forms Data Export
zhlédnutí 10KPřed rokem
How to use GPT-3 with Google Forms Data Export
Can you use AI models to do your work?
zhlédnutí 172Před rokem
Can you use AI models to do your work?
How to use AI like GPT-3 in Google Sheets
zhlédnutí 74KPřed rokem
How to use AI like GPT-3 in Google Sheets
How to Use AI for Email Marketing in Google Sheets
zhlédnutí 1,2KPřed rokem
How to Use AI for Email Marketing in Google Sheets
Getting Started using AI in Google Sheets
zhlédnutí 3,8KPřed rokem
Getting Started using AI in Google Sheets
How to Categorize surveys to understand CSAT, Churn, and feedback in Sheets or Excel
zhlédnutí 250Před rokem
How to Categorize surveys to understand CSAT, Churn, and feedback in Sheets or Excel
How to pull out and calculate numbers from text in Google Sheets or Excel
zhlédnutí 462Před rokem
How to pull out and calculate numbers from text in Google Sheets or Excel
How To Automatically Generate Amazon Listing Descriptions Using AI In Google Sheets
zhlédnutí 446Před rokem
How To Automatically Generate Amazon Listing Descriptions Using AI In Google Sheets
Getting starting in PomptLoop ⚡️ Example
zhlédnutí 827Před rokem
Getting starting in PomptLoop ⚡️ Example
How to analyze AirBnb reviews for sentiment and content in Google Sheets
zhlédnutí 102Před rokem
How to analyze AirBnb reviews for sentiment and content in Google Sheets
PromptLoop
zhlédnutí 2,1KPřed rokem
PromptLoop
PromptLoop
zhlédnutí 481Před rokem
PromptLoop

Komentáře

  • @chrisder1814
    @chrisder1814 Před 12 dny

    hello is it possible to automate SEO with make

  • @ThornBoyz2207
    @ThornBoyz2207 Před 20 dny

    Wish there was an option to turn the subtitles off.

  • @cgc2300
    @cgc2300 Před 21 dnem

    hello

  • @MikeMcKean-pj9in
    @MikeMcKean-pj9in Před měsícem

    It won't seem to bring back a table of data. I.e. we are looking to pull lists of menu items or business locations or items they offer for sale. i.e how do you get it to populate a table of data from a webpage?

  • @pratyushsrivastava6646
    @pratyushsrivastava6646 Před měsícem

    I can help you where to connect

  • @pratyushsrivastava6646
    @pratyushsrivastava6646 Před měsícem

    Hello

  • @NaturallyYours6
    @NaturallyYours6 Před měsícem

    can we put google as website link to find all the cpa websites in a particular city/country?

    • @promptloop4510
      @promptloop4510 Před měsícem

      This is a slightly different task but we have a video coming on this soon.

  • @oliverhill5964
    @oliverhill5964 Před měsícem

    For example of key people retrieval, could it link straight to their Linkedin accounts? Great tutorial didni't know this was possible

    • @promptloop4510
      @promptloop4510 Před měsícem

      Hi Oliver! Going to try to walk through this in a future video. Stay posted!

  • @TheRushabhy2k
    @TheRushabhy2k Před 2 měsíci

    na it does not solve my problem, i would like to have data extract or scrapping from zoominfo, does this can help?

  • @carlos_mann
    @carlos_mann Před 2 měsíci

    I don't understand how to do this, how much would it cost to make a simple scraper formula for me to collect various attributes regarding song information that I am wanting to extract from a site. The site has multiple pages with various musical tag info I am wanting. I know what information I am wanting to extract but I am clearly missing something bc I receive errors everytime and it is extremely aggravating. Please can someone help

    • @promptloop4510
      @promptloop4510 Před 2 měsíci

      Hey Carlos! Thank you for the comment. Its hard to understand exactly what you are looking for but if you want to schedule a free product Demo with the team here promptloop.com/demo we should be able to help or point you in the right direction.

  • @tommasobeq9329
    @tommasobeq9329 Před 2 měsíci

    Thx

  • @txdegoable
    @txdegoable Před 3 měsíci

    Its not FREE quit gaslighting everyone, its free to goof around but why would someone build an entire spreadsheet only to have pay for the data

    • @promptloop4510
      @promptloop4510 Před 2 měsíci

      Hey! Thank you for the note. As of time of writing we offer all capabilities and models to try for free on our free tier. We do have to limit how many data points your can run at a time but our pricing is about 4x as cheap as competitors so we feel this is quite generous!

  • @user-cx6rg6mr7d
    @user-cx6rg6mr7d Před 3 měsíci

    loop cannot handle dynamic generated webpages

  • @robertue1
    @robertue1 Před 4 měsíci

    I tried to use it for inferences but it didn’t really work. Maybe it doesn’t work with Spanish.

  • @rmarazi
    @rmarazi Před 4 měsíci

    The best content of its kind i've found. Thank you!

  • @oliverhill5964
    @oliverhill5964 Před 4 měsíci

    Good timing as always

  • @Experternas
    @Experternas Před 5 měsíci

    Unwatchable. The stupid text is killing me. What the fuck were you thinkkng adding that in. Especially when youtube already has that function

    • @promptloop4510
      @promptloop4510 Před 4 měsíci

      Sorry this was annoying for you can leave it off next time

    • @BieelsZaitsev
      @BieelsZaitsev Před 4 měsíci

      that is a very harsh comment for a free and good quality content

    • @Experternas
      @Experternas Před 4 měsíci

      @@BieelsZaitsevI suppose. I was in a bad mood, i regret and take it back. i still hate the added auto caption but i will keep my mouth shut about it.

    • @nkaurum3482
      @nkaurum3482 Před 3 měsíci

      @@Experternas I respect the fact you owned up and apologized. Kudos

  • @ReformationsGlassArt
    @ReformationsGlassArt Před 5 měsíci

    this was great - thank you

  • @Kinzey
    @Kinzey Před 6 měsíci

    Nice work

  • @truckfinanceaustralia1335
    @truckfinanceaustralia1335 Před 9 měsíci

    Great vid! I will check out promptloop. can you please upload future vids in HD? It is hard to read the text on the spread sheet.

  • @rolejarczyk
    @rolejarczyk Před 9 měsíci

    W

  • @alexmoran8970
    @alexmoran8970 Před 9 měsíci

    It does half the list of starting quarterbacks before stopping and saying I need to pay for a subscription. It is also very slow. I'd think Google will be adding this functionality for free in the near future. Thanks for the demonstration of what it's capable of if you subscribe.

  • @cgc2300
    @cgc2300 Před 10 měsíci

    hello, does it work with gpt4 API ?

  • @SD-rg5mj
    @SD-rg5mj Před 10 měsíci

    bonjour j'ai pensé à utiliser l'intelligence artificielle pour me faire mes catalogues de produits pour le e-commerce , qu'est-ce que tu en penses ? en tout cas merci beaucoup de cette vidéo

  • @SD-rg5mj
    @SD-rg5mj Před 10 měsíci

    hello does it work with images too?

  • @okorinokori7872
    @okorinokori7872 Před 11 měsíci

    Please don't use any background music in future videos.

  •  Před 11 měsíci

    hiding the formula with the webcam wasnt a genius move.

  • @marccj7277
    @marccj7277 Před rokem

    Is it still working ? How does it works on google sheets ?

  • @scrollblau2262
    @scrollblau2262 Před rokem

    Wow this is so useful!

  • @QuantApplicantMattKulis

    just started playing with promptloop, fun stuff , thanks!

  • @eloc86
    @eloc86 Před rokem

    This is incredible. Amazing way to superpower GPT. I hope your goal is acquisition so they don't just steal the functionality or something like Bard syncs with Sheets in 6 months.

  • @eloc86
    @eloc86 Před rokem

    Those pupils, Adderall is super cool

    • @GuidoLoko
      @GuidoLoko Před 3 měsíci

      YUMMMMMMMMMMMMM Yes it is vedy cool lol

  • @kyleanderson1043
    @kyleanderson1043 Před rokem

    Cool in theory but implementation is still lacking. Tried to take some word data and convert to actual numbers (the intent of excel / google sheets) and it just sat there and did nothing. When trying the example it worked, but it said lemons were lemons instead of yellow, lol. The Banana and Nectarine answers were correct though. Maybe we'll be at a good point in a year or two.

  • @SquadUp1019
    @SquadUp1019 Před rokem

    YES!!!! Thanks for getting to the point. There are SO MANY ppl who ramble on for 10+ mins for the same info.

    • @promptloop4510
      @promptloop4510 Před rokem

      Glad it was helpful!

    • @SD-rg5mj
      @SD-rg5mj Před 10 měsíci

      do you think this technique also works with images

  • @SenoSbds
    @SenoSbds Před rokem

    This show when i try login account " Access blocked: This app’s request is invalid "

  • @HECTORARTUROA
    @HECTORARTUROA Před rokem

    Can the extension work without the template? #basededatos #canalpetermangan #depago #descripcionesdeproductos #extensionpromptloop #fuentes #generaciondecontenidod #googledocs #googlespreadsheetd #ia #microsoftexcel ❎ #tabla

  • @TyrandeSusurravientos

    No funciona en Español pero está genial

    • @bickair1
      @bickair1 Před rokem

      lograste encontrar algo en espñaol?

  • @swankehlou
    @swankehlou Před rokem

    doesnt work

  • @tt703
    @tt703 Před rokem

    Template unavailable ...

    • @promptloop4510
      @promptloop4510 Před rokem

      Updated! docs.google.com/spreadsheets/d/1AxQn2si3K6REtYQI6vCJokNlz5c3HFPszz8ZT2LfNDc/template/preview

    • @tt703
      @tt703 Před rokem

      @@promptloop4510 Thanks a lot Peter!

  • @Shahbaz806
    @Shahbaz806 Před rokem

    Good word, plz make a video for Data scripting using Google sheet

  • @daleplotzki7090
    @daleplotzki7090 Před rokem

    It seems good at replicating text, but not so great at analyzing numbers, even when a rubric/description of those numbers is referenced. Any thoughts on this?

  • @MoatazRaafat
    @MoatazRaafat Před rokem

    Dear Peter, i made all your instructions but it keep saying complete account setup or re-active in dropdown menu to continue with credits!

  • @mr.hackathon
    @mr.hackathon Před rokem

    It's great, does require a little cleaning up though

  • @sammyxf6992
    @sammyxf6992 Před rokem

    amazing work it worked like a charm with no issues😀

  • @oliverhill5964
    @oliverhill5964 Před rokem

    this is crazy cool. used it to clean up and transform a very old and messy customer prospecting sheet. adding this to my workflow

  • @haohuynh464
    @haohuynh464 Před rokem

    Can It extract text from string ?

    • @promptloop4510
      @promptloop4510 Před rokem

      Yes - this is the sort of operation PromptLoop is great at. Just extract text from a few examples and you should be good to go!

  • @brandongarland1841
    @brandongarland1841 Před rokem

    when I do this, it's pulling in data from the cells above and NOT the one directly left of the prompt. Any reason why? I'm doing exactly what you are doing in the video

    • @brandongarland1841
      @brandongarland1841 Před rokem

      UPDATE: Nevermind, figured it out. You just have to elminate doign stuff like "doesn't" it has to be "doesnt"

  • @marabrock9036
    @marabrock9036 Před rokem

    I had to watch it twice 👍!!! Get the results you deserve > "Promo sm" !!!

  • @nfish111
    @nfish111 Před rokem

    Can I get help with specific applications?

    • @promptloop4510
      @promptloop4510 Před rokem

      Reach out to the team we have plenty of ways to customize for specific applications. That’s where you really start to see value here.

  • @itscoleonyoutube
    @itscoleonyoutube Před rokem

    Hi! Love this tool. I am playing with it I randomly get the response- #ACCOUNT Complete account setup... Telling me to get credits. How do I make this process without the error? Do I need to create some sort of paid account with promptloop?

    • @itscoleonyoutube
      @itscoleonyoutube Před rokem

      I answered my own question and found the link. It is in the Extensions menu if anyone reads this in the future.

    • @promptloop4510
      @promptloop4510 Před rokem

      Hey! Yes we will make that more clear in the setup process. You can start your trial without and account and make one later using the drop down link. Glad you found it and thanks for sharing the answer here!