Видео

Hi, I'm getting a "reference error" that email template is not defined? Would you know how to fix that. My code is identical to yours for all practical purposes

Great video, I have done the relavent changes but the email is not triggered automatically. Each time I need to run it to get the mail triggered when a new row is added. Is there a way to make sure the mail is triggered automatically as soon as a new row is added?

After initial mail How can i do follow up mail in the same thread

Great video! You have a good cadence in your teaching. I am quite into this topic and had a burning question that I wanted to jot down before I got distracted. Excuse me if you cover this further on in the video, or maybe you have another video covering my question specifically. Do you have any lessons, resources, or maybe a Chrome extension that could help me with this? I'm looking for a way to use a Google Sheets workbook. Ideally, I'd have a sheet containing a product name or some other descriptive information laid out in a table. I want to be able to query against any cell's data and an e-commerce site of my choosing. I need certain data returned and populated into the table. Example: I have a list of routers with certain capabilities. It's an ever-changing product category, so new models come out and others are discontinued. I want to use this table and be able to cross-reference it against one or more major e-commerce sites. When a router has a listing, I want the table updated to show it's still available. I also want to return values like price, URL of the listing, and maybe other data points that exist on the listing(s), all populated into the table. This way, I can have an automated version of this document, since it takes a tremendous amount of time to do manually. Secondly, I'd like to be able to use another data point from the table to pull back new products. For example, this table of routers has specific technology capabilities or chipsets that enable them to function as desired. Other routers may switch these chipsets, or new routers may become available. I'd like to be able to return any and all that do so. These results would populate a new sheet with the required data points, such as: * URL to listing(s) - (What if there are more than one?) * Price * Specific keywords that were found that caused the data to be returned * Date the data was updated * Quantity available * Maybe the number of reviews and the review score/rating Basically, I need to update a product listing against listings on e-commerce sites, returning extra data points specific to the product. The first automation is finding specific models of a product. Then, on another sheet, I want it populated with all listings that match a specific data point query - I guess somewhat of a filter. This would return any and all listings where that specific data is contained. Now that I think about the above, I'd be redundantly duplicating work. I really just need to run the second automation, which would return all I'd need. Then, I could (is it VLOOKUP in Sheets?) cross-reference to see what is available. Anything not found would be considered discontinued. To summarize my request further: I need an automation that scrapes certain site(s), filtering against specific data that would have been contained in an original list. A new sheet would be populated with the specific data points desired. This new list is then cross-referenced against the old listing to determine if a certain product was fetched. If so, that means it is still available for sale. Anything else that wasn't returned would be considered "discontinued."

If I wanted to change the format of the slide to be oriented vertically instead of horizontally, how would you handle?

Your tutorials are great. I've picked up quite a few tips that other tutorials either don't cover or gloss over. One strange thing I found when pressing enter and then tab is that the focus goes to address bar instead of moving over. I'm using Windows, so it may be related. Thanks!

As a non developer but a business owner who is familiar with a few digital tools, this tutorial was an excellent introduction. Hoping this can be the keystone that I need to streamline ops, thank you.

Great video.

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.

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?