วีดีโอ

You’re a great teacher, Matt. Thank you for all your effort. Is there a way to import dynamic data using API public and private keys. I can get it to work in terminal on macOS and then copy and paste into Google sheets, but I can’t get it to work in Google app script.

Hi Matt, I like the script extremely helpful. I have a question if you don't mind. I can run the script and it works as expected but when I do an update to the spreadsheet it never runs the script. What should I be looking at? Thanks,

How can I center and also insert spacing between the lines of a text?

This was amazing

Thank you for the tutorial.

Email receiver doesn’t see sender name they only see the email

How do I get this to happen but a single email go out at ounce

How do you add an attachment to the email. I need to add a .csv to an automated email system. Gmail api and smtp won’t work due to restrictions outside of my control

hi, thanks for the video. I need the onEedit function on all 5 seperate worksheets. Do you have a script I can use or should I do the same function multiple times? thanks!

you can find all the code from this tutorial here: www.mattbrigidi.com/tutorials/google-sheets/how-to-automate-emails-google-sheets/

Awesome content! Thanks for sharing mate

What was the shortcut you used when you selected column B to highlight all other columns to delete?

Need more please. These are so helpful

merci , ça bien marché pour moi

can you link the spreadsheet so i can use the data?

How do you add an alignment center to a program please and thank you

Incredibly helpful! I was missing the ‘date’ component in my query, and it was driving me crazy why it wasn’t working. Also really appreciate what’s going on in the background with what the computer thinks it’s working with (e.g., 2022-06-01). Thank you!

There are only 3 or 4 people on the entire Internet who make such wonderful instructional videos about Appscript and the Google Universe anyway. You, dear Matt, are definitely one of them. I admire people who spend so much time helping others. Thank you very much for this, your videos have helped me a lot on my journey. 💐 I have a question Matt. Is there any possibility to use appscript with an appsheet database ? i use it only with spreadsheets .... but it would be very nice to get access to an appsheet database directly.

@mattbrigidi Hello Matt, I have some questions regarding automated emails, Google Sheets, and Gmail. I have watched a fair number of your videos, but I haven't found the information I need yet. Also, not to lie, I'm not very good at coding. I was wondering if you might have the time to provide some guidance. Thanks Kevin

2 questions. 1 how do you create a new project on python. and 2 can you do another seris like this but how to automate a existing google slide use sheets? Please and thank you.

Hello, thanks for the great video. One question - how would a 22nd line on function 1 would look like if I wanted to extract any changes made to just one column, applying to all existing and future rows? I would really appreciate it.

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?