Automate data collection in Google Sheets

[@lindaduong289]

Out of all the YT tutorials, yours is by far the BEST! You're explaining what you're doing and what each function does rather than just giving a solution. Continue this method please. (gained yourself a new subscriber)

[@mattbrigidi]

Thank you so much for the kind words! I'm so glad you found the video helpful

[@juliamt7511]

Great tutorial! Your explanations makes it so logical, easy to understand the "whys" and "hows". Happy to have found your channel.

[@rohitkumawat6416]

🔥🔥🔥good and so easy to understand.... subscribed and pressed bell icon 😁

[@mattbrigidi]

I'm so glad to hear it - thanks for the feedback and the sub :D

[@nirk1234]

This is too good. I have subscribed.

[@mattbrigidi]

Thank you :D

[@AdelAA060]

Me to

[@tofikqureshi6507]

Hello Sir Pls help me I'm facing the one condition use Google sheet make pivot table need click pivot table showing data as same sheet not new sheet data visible same sheet pls❤help

[@mattbrigidi]

hi, you need to make a pivot table?

[@tim_4g232]

Very good thanks 🙏🙏🙏

[@mattbrigidi]

I'm glad you found it helpful!

[@JohannaDominique-oz3rh]

so cool!

[@mattbrigidi]

thank you!

[@levaaaaaan]

Can this be done with Query and Importrange instead?

[@mattbrigidi]

direct answer: yes, you can abstract answer: depends on the circumstances of your data and environment. the importrange function is a really great option for smaller datasets. it provides nearly streaming updates, which is really great. however, it will start to struggle with larger data sets, which can result in errors, lagged data, and general instability. in my personal experience, i started with importrange and query. it worked very well for quite some time. as my projects grew, importrange started causing critical problems, which is why i transitioned to programming solutions (like the ones in this video series)

[@leidysunday5990]

Can I upload new report on the source data? For exemple, I need to check employee attendance twice a day. So I would upload a report in the morning and then I have to update it again in the afternoon as there may be other employee who arrived late.

[@christianencarnado3530]

my google sheet has no app scripp

[@mattbrigidi]

Are you using a corporate account? Apps Script should be available via the Extensions menu. Let me know if you have issues and we can find a solution

[@Lia.11]

When i try this, it says Spreadsheetapp is not defined, I am not sure why.

[@mattbrigidi]

hey - if you typed “Spreadsheetapp” instead of “SpreadsheetApp” then you will get an error. Apps Script is case sensitive, so that could be the issue. let me know if you still have errors and we can work through it together

[@Lia.11]

It's always the small errors haha, that fixed the code indeed and it works great thank you for this video!! Also I was wondering, personally I am trying to only get the data from the last month from a spreadsheet to be automatically put into another spreadsheet, this code is for all the data in the sheet, do you know if it is possible to just take the last months data? all the data from months of the year is in there and I am monthly trying to extract the data from only the last month for updates, if that makes sense.@@mattbrigidi

[@mattbrigidi]

That makes total sense - it depends on how your date column is structured. Date types can be challenging at times bc of the way humans enter date values and the way humans enter date values. I have a few other videos in this series, which touches on extracting specific data and creating and/or updating another workbook. you can also email me a copy of your workbook (my email is in my about section) - i'm a bit backlogged right now but i can give it a lookover if you'd like

[@ayanrinnopeterdehumo6056]

@@mattbrigidi pls can you send the link if you want to extract specific rows from the source data. i love your video+1Subsriber

[@fittolast2647]

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

[@mattbrigidi]

no need to apologize! glad to hear you’re working through it

[@fittolast2647]

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.

[@mattbrigidi]

sorry this comment was held for review so i’m just seeing this. you had a comment where you said you figured something out - is this the thing you figured out? if it’s still a problem then i’d be happy to help