How to Use ChatGPT in Google Sheets (Full Tutorial)

Поділитися
Вставка
  • Опубліковано 24 лис 2024

КОМЕНТАРІ • 45

  • @Bardeenai
    @Bardeenai  Рік тому

    🔻 Download Bardeen: s.bardeen.ai/Download
    📄 GPT for Sheets: workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654
    🤖 Get emails sent to a recipient in Google Sheets: s.bardeen.ai/46z7akE
    🤖 Save Amazon Product Reviews to Google Sheets: s.bardeen.ai/3tlXPOu
    🧮 OpenAI API Pricing Calculator: gptforwork.com/tools/openai-chatgpt-api-pricing-calculator
    🎓 Scraper Tutorial: s.bardeen.ai/46Rcb8n

  • @orelhassid
    @orelhassid Рік тому +5

    This content is FIRE! 🔥
    I actually get bored with Linkedin scraping videos, this kind of video I really like!

  • @Beanskiiii
    @Beanskiiii 8 місяців тому

    That classify function just blew my mind🤯 Technology is so cool

  • @TheHoneyzap
    @TheHoneyzap 3 місяці тому

    Amazing video, learnt a tonne. Only problem is am going to get poor if I try to use so many AI tools. There are paywalls everywhere. No am not talking about just OPEN AI monthly subscription, I have that! Am talking about the token based pricing for every extension. This GPT extension one also will stop working after a while, when you run out of free tokens and then they will ask for more money. Understandable, it is a business!

  • @neroetal
    @neroetal 8 місяців тому +2

    omg, leaning this 8 months later lol

    • @Beanskiiii
      @Beanskiiii 8 місяців тому

      At least you learned it as sooner than later

  • @chrisder1814
    @chrisder1814 3 місяці тому

    Hello, does it also work with other LLMs?
    do you also use other APIs?

  • @onlytanofficial
    @onlytanofficial 4 місяці тому

    This tutorial is SUPER awesome!! Loved it!! Thanks for sharing.

  • @andriusworkeris1800
    @andriusworkeris1800 8 місяців тому

    Hello. Question - how to sort an exel table if one of the data is GPS coordinates ? I constantly need to sort in groups of 8 nearest coordinates. How can I do it faster?

  • @cgc2300
    @cgc2300 5 місяців тому

    Hello
    I made a product catalog on Google Sheet then I imported this catalog into WordPress
    I was wondering if it would be possible thanks to the combination of Google Sheet APIs, WordPress and the use of n8n software
    that all the keywords present in the description column of each product are automatically replaced by the correct keywords?
    and the same for images?
    THANKS

  • @AdamLundquist
    @AdamLundquist 5 місяців тому

    Do I have to do this by cell or can I do this on a big set for classification?

  • @KreatorVee
    @KreatorVee Рік тому

    This is awesome! I create Google sheet templates as a digital product. Would you know if I use this add on to creat my sheets, will other users be able to use the sheet if they don’t have the add on I used? Please let me know thanks!

    • @Bardeenai
      @Bardeenai  Рік тому +1

      Great question. If you share a Bardeen playbook, anyone can use it with your set up.
      Google Add Ons that you used in a specific Google Sheet should also show up for other users.

    • @KreatorVee
      @KreatorVee Рік тому

      @@Bardeenai awesome! thank you!

  • @business-data
    @business-data Рік тому

    Great thanks. Question: at about 14:15 you have a scraped list from LinkedIn, you say you have all the first names ready for your email campaign, yet it was not able to pull any email addresses off ???

    • @Bardeenai
      @Bardeenai  Рік тому

      Fantastic question, Chris.
      You can find email address using either 1. Apollo Integration 🆕 2. Snov
      There is a way to split the first name using the "Split string" action.
      Hope this helps!

    • @Bardeenai
      @Bardeenai  Рік тому

      How would an ideal workflow for this use case look like for you?
      We've love to make it more intuitive.

  • @mrvictorbassey
    @mrvictorbassey 10 місяців тому

    Somehow, in my case while trying to do this ( 4:25 :Import Data From Your Web Apps), bardeen does not return any results. This is what it says no matter how much I try. "Your last command returned no results"

  • @ryanbrown8387
    @ryanbrown8387 Рік тому

    Bardeen seems like an awesome tool. I definitely wouldnt mind paying for it but I uninstalled after realizing there was a 14 day free trial. I need more than 14 days to get myself comfortable with the app and really feel confident in paying for it. After the free trial is up, is there a free version of it I can use or am I required to pay to use any of the features?

  • @ivanurbina2422
    @ivanurbina2422 Рік тому

    AWESOME!!!

  • @misterjuls
    @misterjuls Рік тому

    Super useful thanks 👍👍

  • @SD-rg5mj
    @SD-rg5mj Рік тому

    hello I would like to have your opinion on several points,
    first of all I thought about using artificial intelligence to fill my catalogs for my future e-commerce business,
    I thought about using chatgpt in Google sheet, what do you think?
    I mean I wonder if this is the best way to do it?
    maybe it would be more interesting to request GPT4 with plugins?
    and regarding Bardeen could you give me some use cases for ecommerce?
    And could bardeen or another AI allow me to show my ads on marketplaces like amazon, ebay...
    and also to do automations instead of make or zapier?
    anyway thank you very much for your videos

    • @Bardeenai
      @Bardeenai  Рік тому

      Using AI inside sheets is a great way to write catchy product descriptions and taglines. But it's important to note that they will be as good as the data you provide.
      Bardeen is great for sourcing that data using its data scraper.
      Do feel free to share your use cases for e-com and we will suggest automations.

    • @SD-rg5mj
      @SD-rg5mj Рік тому

      @Bardeenai in case of use, do you want me to tell you what my intention is? why do i want to use i farted in sheet?
      to make me a catalog of e-commerce products
      Can I send you a PM to tell you more precisely what I want to do?
      and above all, could you give me use cases for using Bardeen for my e-commerce?

    • @chrisder1814
      @chrisder1814 4 місяці тому

      ​@@BardeenaiHello there you are using a Google sheet module but how do you do it with other APIs when there are no modules for

  • @sivakumarp9956
    @sivakumarp9956 Місяць тому

    Sorry Bro this works only on Pro version, "NOT FREE", you should have mentioned it though, because to get API key one has to upgrade to "PRO" version, 'n-ways good presentation

  • @GlobeGreenLLC
    @GlobeGreenLLC Рік тому

    how can i use this on a preexisting set of spreadsheets rather than starting a new sheet?

  • @abdulhameedaltaweel
    @abdulhameedaltaweel Рік тому +1

    Great 👍👍👍

  • @cgc2300
    @cgc2300 Рік тому

    hello I would like to do image description in my Google sheet, can I use other language models than for 3.5?

    • @Bardeenai
      @Bardeenai  Рік тому

      Yes, you can. Click on the "advanced" tab and select the model :)

    • @cgc2300
      @cgc2300 Рік тому

      @Bardeenai can you show me where? I saw the Google sheet doc about using GPT api clearance and it marked that I can choose either gpt 3.5 or Da Vinci text

  • @nexai_official
    @nexai_official 9 місяців тому

    this is insane man... can't tell how many hours could human save just by hitting =gpt_

  • @hassenzouari2479
    @hassenzouari2479 9 місяців тому

    Thank you so much

  • @ProviderKnowledge
    @ProviderKnowledge 11 місяців тому

    thanks

  • @SD-rg5mj
    @SD-rg5mj Рік тому

    Hello, does it work with images?

  • @cgc2300
    @cgc2300 5 місяців тому

    thank you

  • @manishamuwal6001
    @manishamuwal6001 Місяць тому

    Guys anyone ....tell me how chat gpt and google work together 😮its urgent

  • @mmmmmray
    @mmmmmray Рік тому

    Any way to do this without a Chat GPT API Key?

    • @Bardeenai
      @Bardeenai  Рік тому +1

      Yes, you can add an OpenAI action in Bardeen after your scraper action.
      Video about this is coming out later this week.

    • @mmmmmray
      @mmmmmray Рік тому

      Can't wait to see that video!@@Bardeenai

  • @brandonjmclachlan
    @brandonjmclachlan 6 місяців тому

    this mf got a harp in the back

  • @Soul-mw8pe
    @Soul-mw8pe Місяць тому

    FULL tutorial? what a joke