Automate data collection in Google Sheets
Vložit
- čas přidán 6. 03. 2023
- This video will demonstrate how to automate data collection from one Google Sheet to another using Google Apps Script. This video moves a bit fast and is a demonstration on one way to accomplish this goal.
My channel focuses creating lessons to help people learn how to work with data. The intention of these videos is to explain the fundamentals so that you can build data projects. This video is the first on a series about automating data collection in Google Sheets using Google Apps Script.
I think this lesson is a wonderful compliment to my beginner dashboard build: • How to build a dashboa...
If you're interested in learning about the most powerful function in Google Sheets then you can find it here: • How to use QUERY in Go...
I plan on adding modules in the future that will explore other lessons. Please subscribe to my channel if you'd be interested in finding out when I release new material.
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)
Thank you so much for the kind words! I'm so glad you found the video helpful
Great tutorial! Your explanations makes it so logical, easy to understand the "whys" and "hows". Happy to have found your channel.
🔥🔥🔥good and so easy to understand.... subscribed and pressed bell icon 😁
I'm so glad to hear it - thanks for the feedback and the sub :D
This is too good. I have subscribed.
Thank you :D
Me to
so cool!
thank you!
Very good thanks 🙏🙏🙏
I'm glad you found it helpful!
Can this be done with Query and Importrange instead?
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)
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.
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
hi, you need to make a pivot table?
my google sheet has no app scripp
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
When i try this, it says Spreadsheetapp is not defined, I am not sure why.
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
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
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
@@mattbrigidi pls can you send the link if you want to extract specific rows from the source data. i love your video+1Subsriber
Apologies - just found the problem! I'll keep plugging on!
no need to apologize! glad to hear you’re working through it
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.
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