Automating Data Entry into Google Sheets & Excel with ChatGPT & Zapier | Tutorial For Beginners 

Javascript in the tutorial:

 const response = await fetch(inputData["text"]); const text = await response.text(); const words = text.split(" "); output = { result: words.slice(0, 10000).join(" ") };

Incredible Corbin... it is the first time that I received a 40' answer in video... with so much value. The context was other, but you show me the clue. I did the other way you told me, by separating every step, but the expertise you have with zapier is brutal... this way I think I will save several tasks in the workflow! Amzing!

This is my favorite video to date. I'd love to keep seeing advanced zapier use cases with AI. More content like this would be great!

New AI automation services that Leverages social media marketing that would be cool!

Please don't ever stop making videos, your content is more than awesome 🎉huge fan of your work

Navigate to key moments👇 made via tubestamp.com 07:22 - Structuring Google Sheets for data extraction. 09:16 - Importance of consistent outputs and memory key. 16:55 - Demonstration of the automation process. 23:21 - Need for a unique term "XYZ" to avoid repetition. 29:40 - Repeating process for each row due to system limitations. 33:26 - Separating names for client one and client two. 39:50 - Discussing the Subs app and its output. Recap by TubeStamp ✏️

Corbin, you’re an amazing guy. Thanks for the clip!

Amazing. Very useful! Thanks

Thanks Corbin! I was still doubting to use Make or Zapier, did see your comparison. It seems you are leaning towards Zapier, right? Do you think Zapier is more foward/innovative in comparison with Make?

Hi corbin! as always your content is great, I am trying to do the loop thing and I heard that you said that for now you could not load several columns at once from a single loop in zap, do you know if that has been updated? in case you are interested I have a very particular project and it would be a good idea to bring it as content.

Thanks for this explanation, I am now trying to link Discord to Excel using this method, but it now always takes the information from the first message instead of the last new one. Any idea how this could happen? I think something goes wrong somewhere in my javascript run as the input works fine here but the output does not.. Everything else works already. Hopefully you can help me!

Thanks for the great content, you think it can be done with voice input somehow?

This is one of the best video I have seen on automation. I am really new to automations so it was a total eye opener for me. Hats off to you brother. Keep up the good work. And please rekease more video like this. Btw did you automate your youtube comment section as well.

I work in tech recruitment and would like roles received from colleagues to be uploaded to google sheets with various specific data to be picked from everyone's own way of writing. I am trying to use this method but getting stuck by the javascript part as The input cant be the same as the above - please could you help with setting something up for that

Is it possible to take a clients PDF and have the data fill in a custom PDF’s blank spaces. Im really trying to save myself some time and headaches by getting my process automated. Im taking court documents and taking specific information like names and addresses, and placing them on another PDF I’ve made. Is this at all possible or is it asking to much to have an auto fill?

Hey Everyone 👋 Find the parts that interest you: 0:00 - Introduction to AI 1:16 - Viewer inspiration 4:57 - Formatting data with GPT 6:39 - Adding project context 9:14 - Formatting output data 13:19 - Adding to Google Sheet 19:43 - Lookup value explanation 26:44 - Update spreadsheet row 33:29 - Define name 37:12 - Custom row management Recap by Bumpups ✏️

I'm not getting the message output after the javascript block, it's basically outputting sanscript.

Yo Corbin, silly question. How do I have the 2 highlighted in my Google docs haha

If I wanted to hire you to create a fairly similar automation, how would I go about discussing that with you?

Thanks

Hi Corbin, I’m having issues with Javascript you provided. I’m getting Failed to run your JavaScript code. What could be my issue? InputData = text and Insert Data = File Txt const response = await fetch(inputData["text"]); const text = await response.text(); const words = text.split(" "); output = { result: words.slice(0, 100000).join(" ") };

Do you have one that could create and autofill a google doc based off this idea?

Hey Corbin, do you know of anyone I can pay to help me set this up?

Hi Corbin, you only showed 1 item, what about the rest? xD

Hyy