ChatGPT and Google Sheet to Automate the Workflow
Automate Email Marketing / Bulk Emailing 👉🏼 • How to Automate Email ...
See how Bard performed when it was given the same prompt: • Bard AI vs. ChatGPT: C...
In this video, I will be showing you how I used ChatGPT to automate my Google Sheet workflow and send automatic emails to my clients with a PDF letter attached.
ChatGPT is a powerful natural language processing tool that allows you to create chatbots and automate various tasks. In this tutorial, I will be demonstrating how I used it to streamline my client communication process by generating the Google Apps Script code that can generate personalized PDF letters and automatically send them to my clients via email.
Whether you're a small business owner looking to save time on administrative tasks or a freelancer looking to automate your workflows, this tutorial will show you how ChatGPT can help you streamline your processes and free up more time for the things that matter most.
So if you're ready to learn how to use ChatGPT to automate your Google Sheet workflow and send automatic emails to your clients, be sure to watch the video until the end!
Link to code file:
github.com/MAN1986/LearningOr...
Video link on how to integrate OpenAI API with Google Apps Script:
• AI Blog: OpenAI API (C...
#chatgpt #openai #googleappsscript
I'm really fascinated for the huge possibilities of these technologies. Yes, this technology could probably replace many programmers, but I'm sure people can get a lot of benefits from it.
Y'all try using Undetectable AI Human auto typer to write your essay. Saves more time doing other task
ChatGPT really can help a lot to generate the code for excel for all types of users. Great!
Absolutely!
That is really good. 👏👏👏 Thanks for the tutorial.
You’re welcome 😊
Wow this is amazing
Thanks :)
bonjour est-ce qu'il est possible de faire la même chose avec une autre intelligence artificielle ? en tout cas merci beaucoup de tes vidéos
nice one- really helpful in clearing the doubts
Glad it was helpful!
This is amazing! Thanks for this video! Do you know if there’s a way to send emails without a PDF but just having all the text normally just in the email?
Of course this is possible. Write a detailed prompt to ChatGPT as I diaplyed in this video and follow all other steps shown and it will work.
@@LearningOrbis thanks! I will give it a try!
Awesome!
Thank you!
Sure...It will reduce a lots of Time
Is this possible to use this with google sheets and send email from outlook?
Thank you for the amazing video. Do you have also a script that Gsheet will email this message automatically once someone fillip the gsheet with new info...like gform? Thanks in advance..
I don't have the ready code but I can guide you on this. You need to create a GForm and then write a script on that with onFormSybmit trigger which will execute whenever the form is submitted. The script should take the values from the last row of the gsheet and send email accordingly.
Namaste! So fucking useful future will be great!
Thanks a lot for making this video, Ahaan. Can we also trigger a whatsapp api message through the use of scripts? we currently have to use automation tools like zapier to achive that.. please do reply me!!!
Google Apps Script can be used to integrate any API and I am pretty sure , it should work with WhatsApp API as well.
@@LearningOrbis It will be great if you can make a video in it, I will also try to use chatgpt to make a script for whatapp api, as we pay heavy price for automation tools.
Yes I know Zapier costs a lot. I can plan this video but can take a couple of weeks.
Did u do it?😁
Amazing, how can it create graphics from a Google sheets database?
Hi, I have another video where I have showed how to generate Text and Image in Google Doc via ChatGPT. Here is the link: kzhead.info/sun/p86Oqc-mq3SFa4E/bejne.html
Here is new video on creating graphics from Google Sheet database: kzhead.info/sun/bK9ymKhoqYqFgYE/bejne.html
@@LearningOrbis nice, I'll have a look thank you very much
I am really in need of achieving a similar task to this one. Only difference would be that I need to send a different link to 18 different recipients. Do you all think this would work ?
Of course, this will work.
I'm getting a "Script function functionName could not be found".. any idea how to ensure the function is being called correctly?
It seems you did not add the function to the Button. Please follow the procedure describe from 03:11 to 03:40
Will it require some paid api??
Not at all. It's all Google Script and free to use.
I want to use that Google Doc texts as email body copy instead of PDF. How to do that? @learningorbis
Ask chatGPT 😁😂 Did you try that?