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

[@Corbin_Brown]

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(" ") };

[@RoboService-Sweden]

Hi, I keep geting the error in the code by Zap : Failed to run your JavaScript code Error: only http(s) protocols are supported Pleas help

[@EricHardek]

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!

[@Corbin_Brown]

More to come!

[@EricHardek]

@@Corbin_Brown Excellent. I own a P&C insurance brokerage. These automations have changed my business. Keep up the great work!

[@jguillengarcia]

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!

[@Corbin_Brown]

Glad it was helpful!

[@StayStoic__]

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

[@Corbin_Brown]

Thank you so much 😀

[@wachid2832]

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

[@alexishailey6673]

Yes!!!!

[@Corbin_Brown]

Thanks you for the suggestion!

[@HankScorpio94]

How can do set this up to repeat this function a number of times in the same document, to output multiple new rows? I am trying to build an automation that will parse a PDF document for insights and data points and add each insight as a new row in a Google sheet. The difference being I'm looking for like 30 insights per document without duplication. Love your work!

[@Corbin_Brown]

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 ✏️

[@Ishurawatgamer]

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 ✏️

[@InnovativaSourcing]

You a king bro thx so much life saver fr 🥂🍾

[@Corbin_Brown]

🤝

[@seanyoo2138]

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

[@diegomartineztagle8652]

Amazing. Very useful! Thanks

[@davidfilippi4616]

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.

[@rishabhsingh1406]

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.

[@Corbin_Brown]

Thanks! Check out some of our recent videos on PDFs; they also provide valuable insights like this. As for my comment sections, it's me reading and replying, so there's no automation here. Haha!

[@rishabhsingh1406]

@@Corbin_Brown I watched the Pdf videos and they were just as good especially the one where you create the PDF with Slides. They were just pure value. But it also makes me a little overwhelmed and excited with how much we can do with Zapier and Chat GPT. Your channel is really underrated for the value you provide.

[@Corbin_Brown]

@@rishabhsingh1406 Thanks 😃

[@nicholasbx1]

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

[@Rose-360]

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!

[@RikHeijmen]

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?

[@Corbin_Brown]

Thanks for the support! Yeah, I am leaning towards Zapier because of the additional services they offer, such as tables and interfaces. Also, I just enjoy using their UI a lot more!

[@SvenjaRoell]

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

[@iamtanyamarie]

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

[@OlDirtyCosmos]

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?

[@Quinn.condor]

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

[@howiejohnson1678]

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

[@hectorprx]

Thanks

[@nobleokeke9851]

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(" ") };

[@nobleokeke9851]

Is this a Zapier Code issue?

[@alexishailey6673]

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

[@Corbin_Brown]

This is possible. What would be the context for this, and I can look into exploring this workflow?

[@OnMyButterflyJourney]

What about taking all the transactions from square sales and get it into a Google sheet - also getting expenses from CC API and have them put in the sheet and then use a custom gpt to access the data and create profit and loss statements and provide insights about the sales data?

[@carverbennett75]

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

[@Corbin_Brown]

Here is a great resource of automation experts: zapier.com/experts.

[@KLOneShot]

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

[@Ishurawatgamer]

Hyy