Видео

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?

Hey Matt. Loved this video and how you anticipated a lot of my questions. Do you have a video on how to sum data, for example, sum by department, from the data in a google sheet. I passed the data into a dataframe. Looking on how to get away from excel and use pandas/colab for some of my analytical needs.

Hello, Matt! Great video! What if there are multiple recipients that I’d like to send an email to? For example, on the table that you used in this video, there are 20 rows and about 6 email addresses (say in column D). I’d like to code it in such a way that when I run the script, the 6 recipients would be receiving only one email each, and in that email will be a consolidated data/table anchored on their profile/email. Hope you can share your thoughts or make a video 😊

Your tutorials are great and very helpful. Thank you I have gone crazy many nights with your tutorials that work perfectly on the first try when I write them but no longer work when I reopen "Drive" and reload them to continue learning. After rewriting them many times I finally understood that the source "example data file" needs to be opened at the same time as the destination file. Is it possible to take data from the source file that is on the network or on the PC but not yet open on the desktop?

Hi Matt... how if I have a linked chart, and I want it to be updated automatically using appscript? Thank you.

I've managed to add the trigger by selecting "on change" instead of "on form submit". But when I submit the form, I don't receive any email. I only receive an email when running the script manually. I've checked my Google sheet and it contains a new row, so this change should have triggered the script...

I cannot add the trigger with "on form submit" event. I'm getting this message: "Script authorization failed, please check your pop-up blocker". I've already run my script multiple times and allowed its execution. No errors when running my script manually. I've also tried after disabling my adblocker. Any suggestion?

you clearly deserve to get many more new subscribers

Thanks for the video :) Do you have the script available for download?

I used the same script but getting an error saying ReferenceError: datacollector is not defined. How do I fix this?

i am using a spreadsheet for my contact form. So anything filled on my contact form gets into the google sheets. I used this code for the same sheet to send data as email. It works well on Running the script manually. But i am unable to automate it with triggers for some reason. When someone fills the form i get the data in my sheets but trigger does not automate to send it to my email.

i am trying to create something that will take certain fields/tables out of the doc and copy it into a cell in a sheet, is there a specific video for that?

Hello, I am performing a function to get the sharable link out of multiple files in the drive, however it only seems to be working for G-Drive specific files. It will not get a sharable link for Mov's, mp4's, wav.s etc.. only .docx, .pptx etc.. How can I solve this? Cheers!

i tried this and got error : Exception: Access denied: DriveApp. but i have allowed all permission, any idea ?

Thank you for this video, I was getting really stuck on this part with my personal python project and you just saved me a lot of time!

Is it possible to apply this function to multiple ranges? Like, if I had a list that started at b8 and ended at b17, and the another list that started at b25 and ended at b34, and so on. Say my list has phases, so all of the completed tasks go into their respective area in the completed tab

Great !!! Thanks for share.