วีดีโอ

Thank you for this video! This is pure gold!

is there a way to donwload the script file from what you have already written

very helpful Matt ... as all your videos ... thanks a lot for your work 🍩🍩🍩🍩🍩💐

Excellent video. I am going to Wade through here, all 2 hours! Thank you for posting

Hey Matt! Great video! Just wondering… How can you replace text with the table that’s been made to a certain column? I have a GDocs template of a file ready and now I want my table, up until a certain column, to replace the tag I’ve set on the template file.

Thank you so much! I used the workflow builder and make some changes, and it worked!

Amazing video and the way how you explained the process was so clear. Please allow me ask this. Is the message sent only if the new data was input to the GS or is it also sent when the existing data was changed for example the amount. Thanks again for your video.

Hi Matt Great video! I’m interested in learning how to schedule a Slack notification using Google App Script. Could you share some insights on how to set a specific date and time for that? Thanks!

Thank you so much for the video!! If I want the email to be sent out with a constant CC to one particular email, how do I add on or adjust the code?

@Matt, Thanks, great job.

Hey y'all, if anyone else got the error (or similar): ReferenceError: sheets is not defined getSheetById @ getSheetById.gs:10 main@Code.gs:4 You may have a small typo on the getSheetById.gs file, make sure everytime you mention 'sheets' it matches the variable name you set on line 7 I had it set to say 'sheet' instead of 'sheets' and was throwing back this error, and now it works. Hope that helps.

Very good video and nice work. Thanks a lot.

I use Col1, Col2, Col3,.... instead of using A, B, C,... Which one would you recommend ? (Once I had a unsolved problem with using A, B, C in Select statement.)

Hello thank you for this tutorial! Is it possible to get a copy of your code?

Hi Matt, Is there a script for moving any new files that appear in Drive to a folder (e.g.) Inbox so they can be sorted as part of a daily review

This was such a lifesaver thank you so so much for making this video. Very easy to follow and I would say i'm a beginner!

I try to copy your code sir but it returns an error stating 'e:undefined' and soon when I call 'e' e.g. 'e.source'. Hope to get some answer from you sir. Thank you so much in advance.

Every one of the tutorials I found talks about how to read from a Google Sheets file, I can't find anything talking about a Google Document. I think a lot of this would apply, but a specific focus on doing that would be useful. (Great tutorial btw, I learned quite a bit here despite not needing to know how to read from any of these formats)

Is there a way to track who the task was assigned to, or completed by? We assign tasks using comments, but this doesn't display the person's name in the field.

Thanks for this video! It was so helpful! The only issue I ran into was that I couldn't find the Slack channel I wanted to add the app to in my list of available channels. Any thoughts on how to fix that?

Awesome video Matt, thank you. I need this but I also need to put the "paragraphs" in a specific part of the document where I had a "Placeholder" for these. do you have a video for this? or How should I use write it?

great video Matt!! I have a question, if I have a template and I need to add this text but in a specific part of the document, what types of consideration should I need to be aware?

Is there a way to do this, but to a specific location in a doc template? I have the doc template made, it makes a copy of the template, and adds values into specific locations, but I cant figure out how to add the dynamic table into a specific location. Any tips?

How do you send an email if there is no email column on the spreadsheet? I have the setting set to verified, not user input - to make it easier for the person filling in the form, but this seems to make retrieving the email more difficult within the apps script

Amazing video! Thank you! One note to benefit the community, regarding minute 50:18, Flavor /"Lattice": From chatGPT 🙏: 1. Lattice Method ("lattice"): How It Works: The lattice method works by looking for lines in the PDF that form the boundaries of tables. It searches for the structure of tables by identifying the lines that make up the rows and columns. This is effective when the tables in the PDF have clear borders or gridlines, as it can accurately detect the cells within the table. Best Used For: PDFs where tables are well-defined with visible lines or borders. Default Choice: The lattice method is the default because it's generally more reliable for extracting tables that are neatly formatted with gridlines. 2. Stream Method ("stream"): How It Works: The stream method, on the other hand, doesn't rely on borders or gridlines. Instead, it looks for text that is aligned in a tabular format. It tries to infer the table structure based on the relative positions of the text in the PDF. This method can be useful when the tables don't have clear borders but still have a consistent layout. Best Used For: PDFs where tables are not clearly defined with lines but are instead organized with spacing or alignment. Why Choose One Over the Other? Lattice: Use this when your PDF has tables with clear, visible lines or borders. It is often more accurate for these types of documents. Stream: Use this when your PDF has tables without clear borders, relying more on the alignment of text.

Thank you for this video, Matt. I watched the entire thing and was able to generally understand. The only concern/help I have is that I thought this script would copy all tabs in addition to the working tab. Is there an easy way to add that into the script such that the new workbook created also includes the other tabs in the original workbook? Thanks again!

The function already delete by default sir, are any other way sir?

Perfeito! excelente aula. Parabéns.

Great video, learned a lot. Thank you Have a question: Can we create documents with tables, separated by a line?

for line 45 of the code, I got the error message "Exception: The sheet name cannot be empty." any idea why?

Thank you for this video. I also had the same error as some above. TypeError: Cannot read properties of null (reading 'getSheets') getSheetById @ getSheetById.gs.gs:7 main @ Code.gs:4 I copied your code so not sure what I am doing wrong. I tried to find your email in the about section but I must be blind. haha Did anyone else figure out this error?

I get all the way to the end, it's running properly, testing comes back as it should, but then when I delete the "catch" from line 22 it doesn't execute as it should, I have started over from start to finish 4 times now and still the same result. Any tips on what I could be missing? This video was so helpful and just what I am looking for but I am struggling to get it to do right!

Hi! This is a very helpful video. Can you help me figure out how to send a static image in Google drive to slack via appscript?

Very clear and easy to follow! Thank you!

Good morning! Thank you for this amazing video. I've been able to run the code with two issues: 1. I need to run it repeatedly to get all the workbooks to be created (I've only got a small data set that I'm working with) 2. Like Samantha below, only the headers are appearing in the workbooks. Any suggestions? I'll look at the code and video as it relates to identifying the source data, but if you have any suggestions in the interim I'd be grateful. Thank you again!

Apologies - just found the problem! I'll keep plugging on!

Good afternoon, Thank you so much for this video series. I've tried this video 6 twice, but each time I keep getting the following error message: ReferenceError: sheetname is not defined getSheetById @ getSheetById.gs:11 dataExtractor @ dataExtractor.gs:2 main @ Code.gs:10 I'm not sure what I'm missing, and as this is at the outer edges of my comfort zone I'm not sure where to look :-) Any suggestions would be greatly appreciated.

It's so amazing and interesting with your serie of videos. Could you please give us a video that we want to send email (Google email) to every response recipient with their separate chart and data (Google sheet). Many thanks.

😊

For my german friends out there, as I spent 30 mins figuring this out, with german localization you need to use "\" to seperate the ranges in the array

By any chance can you share the code?

Thank you! this is excellent! the trigger should be for the 'dataCollector' function and not the 'opener' function, yes?

This is excellent! THANK YOU! How would I automate data collection from only ONE sheet (the 'Data' tab) from multiple workbooks to 1 sheet? I need each person to have their individual workbook so that they don't mess up anyone else's data. But each person's WB has multiple tabs (for drop-down menus, and guidance and instructions). So I need to gather only the 'Data' tab of each WB.

Hey Matt, I have noticed that a lot of your recent videos are related to Data Visualization techniques using Python as the programming language, I was wondering if there can be some projects that can be made using this, I actually don't know a lot because I am still in the first year of college but I did make one project that displayed Spotify's data like (top 10 songs, heatmaps of various aspects of the song etc) I did take a lot of help ofc I couldn't do it all by myself, I had to watch tutorials understand it and then implement it in my project but I was wondering if you could come up with something that's maybe something like this or anything actually it'd be really great because I don't really work on Data Visualization actively at the moment but would really like to jump in haha anyway thanks for reading this Matt :)

Thanks for the Video

How would you handle it if the email address were a group? I think it may have to parse the group in order to send but I am a newbie and have no idea what I am even saying.

Yeah you explain it well sir, really thank you

Hi, Matt. How can I include the email of the responder of the form as recipient when sending the email? I assume I need to find the last row in the linked sheet but not sure how to do that in the code.

How would I use the push to put the name in the beginning of the array so that the name is in the first column?

how define which folder the doc will be saved?