Peter Mangan
Peter Mangan
  • 34
  • 119 493
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
มุมมอง: 187

วีดีโอ

Scrape Names and Emails from Websites in 2 Minutes with AI
มุมมอง 11121 วันที่ผ่านมา
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!
มุมมอง 741หลายเดือนก่อน
🚀 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!
มุมมอง 395หลายเดือนก่อน
- 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
มุมมอง 2273 หลายเดือนก่อน
🚀 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
มุมมอง 3484 หลายเดือนก่อน
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
มุมมอง 13K5 หลายเดือนก่อน
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
มุมมอง 720ปีที่แล้ว
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
มุมมอง 428ปีที่แล้ว
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
มุมมอง 2.1Kปีที่แล้ว
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
มุมมอง 627ปีที่แล้ว
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?
มุมมอง 160ปีที่แล้ว
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?
มุมมอง 835ปีที่แล้ว
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)
มุมมอง 2.1Kปีที่แล้ว
SEO with GPT-3: Optimize Your Website to Rank (PromptLoop Template)
How to use GPT-3 with Google Forms Data Export
มุมมอง 10Kปีที่แล้ว
How to use GPT-3 with Google Forms Data Export
Can you use AI models to do your work?
มุมมอง 172ปีที่แล้ว
Can you use AI models to do your work?
How to use AI like GPT-3 in Google Sheets
มุมมอง 73Kปีที่แล้ว
How to use AI like GPT-3 in Google Sheets
How to Use AI for Email Marketing in Google Sheets
มุมมอง 1.2Kปีที่แล้ว
How to Use AI for Email Marketing in Google Sheets
Getting Started using AI in Google Sheets
มุมมอง 3.8Kปีที่แล้ว
Getting Started using AI in Google Sheets
How to Categorize surveys to understand CSAT, Churn, and feedback in Sheets or Excel
มุมมอง 249ปีที่แล้ว
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
มุมมอง 449ปีที่แล้ว
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
มุมมอง 441ปีที่แล้ว
How To Automatically Generate Amazon Listing Descriptions Using AI In Google Sheets
Getting starting in PomptLoop ⚡️ Example
มุมมอง 792ปีที่แล้ว
Getting starting in PomptLoop ⚡️ Example
How to analyze AirBnb reviews for sentiment and content in Google Sheets
มุมมอง 102ปีที่แล้ว
How to analyze AirBnb reviews for sentiment and content in Google Sheets
PromptLoop
มุมมอง 2Kปีที่แล้ว
PromptLoop
PromptLoop
มุมมอง 466ปีที่แล้ว
PromptLoop

ความคิดเห็น

  • @ThornBoyz2207
    @ThornBoyz2207 วันที่ผ่านมา

    Wish there was an option to turn the subtitles off.

  • @cgc2300
    @cgc2300 2 วันที่ผ่านมา

    hello

  • @MikeMcKean-pj9in
    @MikeMcKean-pj9in หลายเดือนก่อน

    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 หลายเดือนก่อน

    I can help you where to connect

  • @pratyushsrivastava6646
    @pratyushsrivastava6646 หลายเดือนก่อน

    Hello

  • @NaturallyYours6
    @NaturallyYours6 หลายเดือนก่อน

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

    • @promptloop4510
      @promptloop4510 หลายเดือนก่อน

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

  • @oliverhill5964
    @oliverhill5964 หลายเดือนก่อน

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

    • @promptloop4510
      @promptloop4510 หลายเดือนก่อน

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

  • @TheRushabhy2k
    @TheRushabhy2k หลายเดือนก่อน

    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 หลายเดือนก่อน

    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 หลายเดือนก่อน

      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 2 หลายเดือนก่อน

    Thx

  • @txdegoable
    @txdegoable 2 หลายเดือนก่อน

    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 หลายเดือนก่อน

      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 2 หลายเดือนก่อน

    loop cannot handle dynamic generated webpages

  • @robertue1
    @robertue1 3 หลายเดือนก่อน

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

  • @rmarazi
    @rmarazi 3 หลายเดือนก่อน

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

  • @oliverhill5964
    @oliverhill5964 4 หลายเดือนก่อน

    Good timing as always

  • @Experternas
    @Experternas 4 หลายเดือนก่อน

    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 3 หลายเดือนก่อน

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

    • @BieelsZaitsev
      @BieelsZaitsev 3 หลายเดือนก่อน

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

    • @Experternas
      @Experternas 3 หลายเดือนก่อน

      @@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 3 หลายเดือนก่อน

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

  • @ReformationsGlassArt
    @ReformationsGlassArt 5 หลายเดือนก่อน

    this was great - thank you

    • @promptloop4510
      @promptloop4510 5 หลายเดือนก่อน

      Glad you enjoyed it!

  • @Kinzey
    @Kinzey 5 หลายเดือนก่อน

    Nice work

    • @promptloop4510
      @promptloop4510 5 หลายเดือนก่อน

      Thank you! Cheers!

  • @truckfinanceaustralia1335
    @truckfinanceaustralia1335 8 หลายเดือนก่อน

    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 8 หลายเดือนก่อน

    W

  • @alexmoran8970
    @alexmoran8970 9 หลายเดือนก่อน

    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 9 หลายเดือนก่อน

    hello, does it work with gpt4 API ?

  • @SD-rg5mj
    @SD-rg5mj 10 หลายเดือนก่อน

    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 10 หลายเดือนก่อน

    hello does it work with images too?

  • @okorinokori7872
    @okorinokori7872 11 หลายเดือนก่อน

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

  •  11 หลายเดือนก่อน

    hiding the formula with the webcam wasnt a genius move.

  • @marccj7277
    @marccj7277 11 หลายเดือนก่อน

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

  • @scrollblau2262
    @scrollblau2262 ปีที่แล้ว

    Wow this is so useful!

  • @QuantApplicantMattKulis
    @QuantApplicantMattKulis ปีที่แล้ว

    just started playing with promptloop, fun stuff , thanks!

  • @eloc86
    @eloc86 ปีที่แล้ว

    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 ปีที่แล้ว

    Those pupils, Adderall is super cool

    • @GuidoLoko
      @GuidoLoko 2 หลายเดือนก่อน

      YUMMMMMMMMMMMMM Yes it is vedy cool lol

  • @kyleanderson1043
    @kyleanderson1043 ปีที่แล้ว

    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 ปีที่แล้ว

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

    • @promptloop4510
      @promptloop4510 ปีที่แล้ว

      Glad it was helpful!

    • @SD-rg5mj
      @SD-rg5mj 10 หลายเดือนก่อน

      do you think this technique also works with images

  • @SenoSbds
    @SenoSbds ปีที่แล้ว

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

  • @HECTORARTUROA
    @HECTORARTUROA ปีที่แล้ว

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

  • @TyrandeSusurravientos
    @TyrandeSusurravientos ปีที่แล้ว

    No funciona en Español pero está genial

    • @bickair1
      @bickair1 ปีที่แล้ว

      lograste encontrar algo en espñaol?

  • @swankehlou
    @swankehlou ปีที่แล้ว

    doesnt work

  • @tt703
    @tt703 ปีที่แล้ว

    Template unavailable ...

    • @promptloop4510
      @promptloop4510 ปีที่แล้ว

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

    • @tt703
      @tt703 ปีที่แล้ว

      @@promptloop4510 Thanks a lot Peter!

  • @Shahbaz806
    @Shahbaz806 ปีที่แล้ว

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

  • @daleplotzki7090
    @daleplotzki7090 ปีที่แล้ว

    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 ปีที่แล้ว

    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 ปีที่แล้ว

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

  • @sammyxf6992
    @sammyxf6992 ปีที่แล้ว

    amazing work it worked like a charm with no issues😀

  • @oliverhill5964
    @oliverhill5964 ปีที่แล้ว

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

    • @promptloop4510
      @promptloop4510 ปีที่แล้ว

      Very cool!

    • @SD-rg5mj
      @SD-rg5mj 10 หลายเดือนก่อน

      can it describe pictures to me?

  • @haohuynh464
    @haohuynh464 ปีที่แล้ว

    Can It extract text from string ?

    • @promptloop4510
      @promptloop4510 ปีที่แล้ว

      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 ปีที่แล้ว

    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 ปีที่แล้ว

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

  • @marabrock9036
    @marabrock9036 ปีที่แล้ว

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

  • @nfish111
    @nfish111 ปีที่แล้ว

    Can I get help with specific applications?

    • @promptloop4510
      @promptloop4510 ปีที่แล้ว

      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 ปีที่แล้ว

    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 ปีที่แล้ว

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

    • @promptloop4510
      @promptloop4510 ปีที่แล้ว

      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!

  • @beachlife8367
    @beachlife8367 ปีที่แล้ว

    I tried the example with the fruit and got mixed results. I added the following fruits and got the corresponding results: Lemon - Yellow Banana - Yellow Nectarine - Purple Orange - Green Grapefruit - Yellow Cherry - Purple Mango - Yellow Dragon Fruit - Purple I then entered Apple again in the list and got Green instead of Red, which is what I put for the first Apple in the list and that was used to show the AI what I wanted to check by. Could I be doing this incorrectly, or is there a weakness in the system?

    • @leopoldh.meinert8352
      @leopoldh.meinert8352 ปีที่แล้ว

      same here, I got: Apple Red Orange Orange Kiwi Green Plum Purple Raisin Brown Lemon Neutral Banana Yellow Nectarine Peach

    • @vishistakanduri5682
      @vishistakanduri5682 9 หลายเดือนก่อน

      tested today, Accuracy is 70% in some cases so if entries are 1000 then probably there would be at least 300 to be cross-checked