How I managed to export contents of emails to Google Sheets with the help of ChatGPT 🤖💪
In this article, I explain how I leveraged ChatGPT to create a Google script that fetches email content to Google Sheets. I want to share this especially with my non-developer friends who might not be aware of the potential of AI tools.
💡 ChatGPT – http://ai.com | cool domain, right?
So, I learned in detail what this code does and how it works. It even commented about how well this code was written!
I checked the code to try to understand what is happening. So, I need a search query and the code does the rest. But how does it connect to my Gmail?
Then I thought why not ask for more help
Ok, that makes sense 🙂 And it works.
This code successfully creates rows on my Google Sheet and adds three columns of information; Date, From Address, To Address. In this case, I need to change the code to fulfill my needs.
I created a label on Gmail and created a filter to label the incoming emails if they include specific words in the subject field, in my case, it is wpforms_entries.
Ok, ChatGPT. Can you just change the code as I request? Here we go again:
After ChatGPT is done, I copy and paste the code to Apps Script on my Google Sheets…. and… viola!
I have the form’s inputs extracted from Gmail on my test sheet! Simply amazing!
The power of AI has enabled a non-developer like me to accomplish this complex(!) task with ease. By using ChatGPT, I created a Google script to fetch email content to Google Sheets in under 10 minutes with the power of AI! 🤖💪! With AI, we can simplify tasks and make them accessible to everyone, regardless of their technical expertise. #AI #GoogleSheets #ChatGPT #Productivity
And, yes, I asked the AI to write the last paragraph.
