How to Use ChatGPT in Google Sheets (Full Tutorial)

Поделиться
HTML-код
  • Опубликовано: 4 окт 2024

Комментарии • 47

  • @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 Год назад +4

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

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

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

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

    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!

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

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

  • @neroetal
    @neroetal 6 месяцев назад +2

    omg, leaning this 8 months later lol

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

      At least you learned it as sooner than later

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

    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?

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

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

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

    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 4 месяца назад

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

  • @mrvictorbassey
    @mrvictorbassey 9 месяцев назад

    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"

  • @sivakumarp9956
    @sivakumarp9956 5 дней назад

    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

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

    thank you

  • @hassenzouari2479
    @hassenzouari2479 8 месяцев назад

    Thank you so much

  • @ProviderKnowledge
    @ProviderKnowledge 10 месяцев назад

    thanks

  • @nexai_official
    @nexai_official 7 месяцев назад

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

  • @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?

  • @misterjuls
    @misterjuls 11 месяцев назад

    Super useful thanks 👍👍

  • @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!

  • @GlobeGreenLLC
    @GlobeGreenLLC 10 месяцев назад

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

    • @Bardeenai
      @Bardeenai  10 месяцев назад

      Yes, absolutely you can.

  • @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.

  • @webinarhackers
    @webinarhackers Год назад +1

    Great 👍👍👍

  • @LightAge1990
    @LightAge1990 10 месяцев назад

    When i open google sheets theres nowhere "set your api key"...pls help

    • @LightAge1990
      @LightAge1990 10 месяцев назад

      I got it solved. U have to insall it from google sheets and not seperate. Thats what i did before. If someone had this problem.

  • @ivanurbina2422
    @ivanurbina2422 Год назад

    AWESOME!!!

  • @manishamuwal6001
    @manishamuwal6001 4 дня назад

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

  • @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 2 месяца назад

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

  • @cgc2300
    @cgc2300 10 месяцев назад

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

    • @Bardeenai
      @Bardeenai  10 месяцев назад

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

    • @cgc2300
      @cgc2300 10 месяцев назад

      @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

  • @SD-rg5mj
    @SD-rg5mj Год назад

    Hello, does it work with images?

    • @Bardeenai
      @Bardeenai  Год назад

      What do you mean exactly?

  • @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

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

    😘

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

    this mf got a harp in the back