Around the 5:55 mark, what if you don't know how many rows of data are going to be there every time? Instead of A2:E2, is there a way I can grab however many rows there are, whether it be 2 rows one day or 10 rows the next? Thanks!
Hi! Can I modify this easily to append data into emtpy columns to the right on Sheet1 as new data appears in a table in Sheet2? Or would that be a whole nother ball of wax.
It's a little bit of a different. If the data appears dynamically, say from an API or a query then you will need to use a time trigger to handle the updates th-cam.com/video/MiWfaCNRzsA/w-d-xo.html
hey, I liked your video but I have a question. Can we use the appendRow method in a specific row location? like for example I wanted the data to start from Q column 100th row.
Hi Muhammed, appendRow() is based on the data region of an entire sheet, so unfortunately, no. I've got a bunch links to alternate solutions in the description. I think you will find one of these will have a solution for you.
@@yagisanatode i have the same question, but if its not possible, is there a way that appendRow() can be used in a sheet that has formula on other columns?
@@trisha_inteli2438 Hi, no appenRow() will navigate to the last row of all the data in the sheet. You can find a tutorial more directly related to your query here: yagisanatode.com/2019/05/11/google-apps-script-get-the-last-row-of-a-data-range-when-other-columns-have-content-like-hidden-formulas-and-check-boxes/
@@yagisanatode so i ended up starting over because it wasnt working and now it tells me "TypeError: ss.getSheetByName is not a function'? i didnt change anything but the sheet name and range from a1:e1 to the location where i have the info which is b8:e8.
@@KopiPaste-zw1bb It looks like you are referencing the entire spreadsheet by calling the `ss` constant variable, rather than the desired sheet. You could try `const targetSheet = ss.getActiveSheet()` for an active sheet.
@@yagisanatode what I need to add here can you please tell me how I rectify that because I still can't understand what I need to do here after watching the tutorial on websites
@@GhoulGamingYT I'm not 100% certain what you need here, sorry. I mention a few gotchas at the end. I'm going to take a guess, apologies if I am wrong. If you need to append data to a row that already contains data in other columns, then you will need to find the last row using these methods yagisanatode.com/2019/05/11/google-apps-script-get-the-last-row-of-a-data-range-when-other-columns-have-content-like-hidden-formulas-and-check-boxes/ then you can apply .getRange(*start row*, *start col*, *data depth*, *data width*).setValues(*data*) replacing values inside the *. I hope this helps.
Thanks for the tutorial, your videos & blog Apps Script has been super helpful. Would you consider doing a tutorial on retrieving data sent via webhooks to a Google sheet?
Hi Brad, Definitely something to add to the list. In the mean time I do have a tutorial on receiving webhook data into a Apps Script webapp and adding the results to a Google Sheet using the Teachable webhooks. The whole process it similar across the board so you could adapt it to your own needs. Here is the link: yagisanatode.com/2021/11/30/how-to-automatically-share-teachable-students-to-google-drive-files-and-folders-when-they-enroll-in-your-course/
What I really want, is to paste the collected Data into a NEWLY INSERTED ROW, 1 Row ABOVE the last Row in the Sheet... Can anyone help me!? This video is very helpful, I have learned a lot! Thank you!
Hi Beaux. That is definitely a good topic for a tutorial. I will add it to the list. In the mean time have a look at sheet.insertRowAfter(1) developers.google.com/apps-script/reference/spreadsheet/sheet#insertrowafterafterposition
You are a saviour!!
Thanks!
You're welcome! Glad it was useful for you.
Around the 5:55 mark, what if you don't know how many rows of data are going to be there every time? Instead of A2:E2, is there a way I can grab however many rows there are, whether it be 2 rows one day or 10 rows the next? Thanks!
Never mind. Just watched the pitfalls section 😭
All good. There are a few other links to different approaches in the description of the tutorial.
Just what I was looking for, thank you :)
Glad I could help!
How do I update a single cell data instead of appending a new row?
You can use something like sheet.getRange("B4").setValue("here!")
thank you too muchs veeeeeery functional
Hi! Can I modify this easily to append data into emtpy columns to the right on Sheet1 as new data appears in a table in Sheet2? Or would that be a whole nother ball of wax.
It's a little bit of a different. If the data appears dynamically, say from an API or a query then you will need to use a time trigger to handle the updates th-cam.com/video/MiWfaCNRzsA/w-d-xo.html
Good job
Thank you!
hey, I liked your video but I have a question. Can we use the appendRow method in a specific row location? like for example I wanted the data to start from Q column 100th row.
Hi Muhammed, appendRow() is based on the data region of an entire sheet, so unfortunately, no. I've got a bunch links to alternate solutions in the description. I think you will find one of these will have a solution for you.
@@yagisanatode i have the same question, but if its not possible, is there a way that appendRow() can be used in a sheet that has formula on other columns?
@@trisha_inteli2438 Hi, no appenRow() will navigate to the last row of all the data in the sheet. You can find a tutorial more directly related to your query here: yagisanatode.com/2019/05/11/google-apps-script-get-the-last-row-of-a-data-range-when-other-columns-have-content-like-hidden-formulas-and-check-boxes/
I keep getting the error message that it cannot read Cannot read properties of undefined (reading 'getRange')
What's happening on the line that the error occurred on?
@@yagisanatode so i ended up starting over because it wasnt working and now it tells me "TypeError: ss.getSheetByName is not a function'? i didnt change anything but the sheet name and range from a1:e1 to the location where i have the info which is b8:e8.
@@KopiPaste-zw1bb It looks like you are referencing the entire spreadsheet by calling the `ss` constant variable, rather than the desired sheet. You could try `const targetSheet = ss.getActiveSheet()` for an active sheet.
@@yagisanatode thankk you so mcuh!!!!!!!!
i dont quite understand as i am very new to this but i really appreciate your reply and help
How we solve that problem which is coming in the end of the video how we solve that
Check out the links in the description. I have a number of tutorials there that will help you out.
@@yagisanatode what I need to add here can you please tell me how I rectify that because I still can't understand what I need to do here after watching the tutorial on websites
@@GhoulGamingYT I'm not 100% certain what you need here, sorry. I mention a few gotchas at the end. I'm going to take a guess, apologies if I am wrong.
If you need to append data to a row that already contains data in other columns, then you will need to find the last row using these methods yagisanatode.com/2019/05/11/google-apps-script-get-the-last-row-of-a-data-range-when-other-columns-have-content-like-hidden-formulas-and-check-boxes/ then you can apply .getRange(*start row*, *start col*, *data depth*, *data width*).setValues(*data*) replacing values inside the *. I hope this helps.
@@yagisanatode ok thanku
Thanks for the tutorial, your videos & blog Apps Script has been super helpful. Would you consider doing a tutorial on retrieving data sent via webhooks to a Google sheet?
Hi Brad, Definitely something to add to the list. In the mean time I do have a tutorial on receiving webhook data into a Apps Script webapp and adding the results to a Google Sheet using the Teachable webhooks. The whole process it similar across the board so you could adapt it to your own needs. Here is the link: yagisanatode.com/2021/11/30/how-to-automatically-share-teachable-students-to-google-drive-files-and-folders-when-they-enroll-in-your-course/
Thank you, I am sorry I cannot afford these days a price of a cup of coffee!:(
What I really want, is to paste the collected Data into a NEWLY INSERTED ROW, 1 Row ABOVE the last Row in the Sheet... Can anyone help me!?
This video is very helpful, I have learned a lot! Thank you!
Hi Beaux. That is definitely a good topic for a tutorial. I will add it to the list. In the mean time have a look at sheet.insertRowAfter(1) developers.google.com/apps-script/reference/spreadsheet/sheet#insertrowafterafterposition
How to append Multiple columns
Check out the links in the description. You should find something there that will help you ;) .