You're an animal. Thanks for the vids brother. As an SEO consultant I was getting tired of all the time consuming monotonous tasks I have to do. I'm no novice with Excel and Google sheets but you my friend have elevated my game. Easily saved me tens of hours of work. I'm happy to support your patreon.
First of all thank you for all the videos you make, they are very helpful. I'm following your instructions from this video, the file is connected but I get the errror: FATAL ERROR: MarkCompactCollector: young object promotion failed Allocation failed - JavaScript heap out of memory. I already increased the total heap size to over 10,000 GB and am still getting this error. The size of the connected excel file is 184 MB and has almost 2,000,000 rows and 9 columns. Is this file just to large to access/use? If so, do you know if there is an other solution? Maybe you can refer me to one of your many videos for a solution. Thank you very much.
Please HELP! How can i fix this? UnhandledPromiseRejectionWarning: TypeError: Cannot read property 'values' of undefined at gsrun (C:\Users\Raphael Pereira\Desktop\google-sheet-api-project\main.js:30:23) at C:\Users\Raphael Pereira\Desktop\google-sheet-api-project\main.js:18:7 at C:\Users\Raphael Pereira\Desktop\google-sheet-api-project ode_modules\google-auth-library\
hello, i hope you're doing well. first of all excuse my english if i am not verry clear, i am a french guy😊 Now i have tried to do the same work following you but i am blocked at the installation of exceljs packages. here is the error : internal/modules/cjs/loader.js:330 throw err; ^ at tryPackage (internal/modules/cjs/loader.js:322:19) at Function.Module._findPath (internal/modules/cjs/loader.js:683:18) at Function.Module._resolveFilename (internal/modules/cjs/loader.js:953:27) at Function.Module._load (internal/modules/cjs/loader.js:842:27) at Module.require (internal/modules/cjs/loader.js:1026:19) at require (internal/modules/cjs/helpers.js:72:18) at Object. (C:\Users\Ousmane\Desktop\sheets-api-project\main.js:3:17) at Module._compile (internal/modules/cjs/loader.js:1138:30) at Object.Module._extensions..js (internal/modules/cjs/loader.js:1158:10) at Module.load (internal/modules/cjs/loader.js:986:32) { code: 'MODULE_NOT_FOUND', path: 'C:\\Users\\Ousmane\\Desktop\\sheets-api-project\ ode_modules\\exceljs\\package.json', requestPath: 'exceljs' i run this command --- npm list --depth=0 -- to verify all packages installed and the result is : ┌──────────────────────────────────────────────────────────────┐ │ npm update check failed │ │ Try running with sudo or get access │ │ to the local update config store via │ │ sudo chown -R $USER:$(id -gn $USER) C:\Users\Ousmane\.config │ └──────────────────────────────────────────────────────────────┘ sheets-api-project@1.0.0 C:\Users\Ousmane\Desktop\sheets-api-project +-- exceljs@4.0.0 `-- googleapis@39.2.0 apparently the apckage is present but it does not work. i tried every things but still blocked please can you give some help. thanks in advance.
Sorry, the space where I was recording has gotten too noisy to produce anything, so I had to take a break to find a different solution. New videos should be coming next week.
You're an animal. Thanks for the vids brother. As an SEO consultant I was getting tired of all the time consuming monotonous tasks I have to do. I'm no novice with Excel and Google sheets but you my friend have elevated my game. Easily saved me tens of hours of work. I'm happy to support your patreon.
Thanks for the videos!!!!!! You automate my life
OMG Amazing!!!! Where is the part 1 of the tutorial???
th-cam.com/video/MiPpQzW_ya0/w-d-xo.html
Thank you very much, you are very good teacher. Very clear explanations. GBU
You are a life saver!!
Amazing!!! Thank you very much for your channel!!!
thanks a lot 🥰❤
Please do more Google Docs videos ;]
excellent video, Thank you
will it be able to copy the template if the template has formulas ?
You are super! How am i able to import columns that only matches the labels (of first row) in my spreadsheet?
Excellent video.
Is there any way where we can create google sheet through same program API and then push the data into it
Yes, of course.
Hi please can you share link for part 1 how to download node.Js
With a +50.000 rows, 5 columns Excel file will be this method efficient ? Excellent video !
It should be fine.
First of all thank you for all the videos you make, they are very helpful. I'm following your instructions from this video, the file is connected but I get the errror: FATAL ERROR: MarkCompactCollector: young object promotion failed Allocation failed - JavaScript heap out of memory. I already increased the total heap size to over 10,000 GB and am still getting this error. The size of the connected excel file is 184 MB and has almost 2,000,000 rows and 9 columns. Is this file just to large to access/use? If so, do you know if there is an other solution? Maybe you can refer me to one of your many videos for a solution. Thank you very much.
Create videos on Google Glide ... please!
hello! how can i trigger this code by events on google sheets or excel. Can you help me pls
Hey there, I have a column with only links and want to hide the in front of all links but still want them to be clickable. How can I do that?
As you have fetched the whole row.I want to fetch just data column wise.How to do that
in part1
How to run this async function gsrun repeatedly? tried with setinterval but showing login error.
I need to import data from Google Sheets into Excel. Is it the same process and do you have a video on that?
Yes, it's the same process. You can watch this for extra info th-cam.com/video/MiPpQzW_ya0/w-d-xo.html
Is there a reason why you wouldn't use batchUpdate rather than update?
How can I do to make a dropdown in Google Sheets that show labels (eg: person name), but when clicked write an id value in the cell (eg: person id) ?
Hi can we capture facebook leads in google sheet pls make a video on that
How about if I import csv file?
can i do the same thing in visual basic
Sure.
@@ExcelGoogleSheets need some help with this as I am completely new to this .. it would be great if you could provide some information.
How to update automatic in google sheet through this script
Please HELP!
How can i fix this?
UnhandledPromiseRejectionWarning: TypeError: Cannot read property 'values' of undefined
at gsrun (C:\Users\Raphael Pereira\Desktop\google-sheet-api-project\main.js:30:23)
at C:\Users\Raphael Pereira\Desktop\google-sheet-api-project\main.js:18:7
at C:\Users\Raphael Pereira\Desktop\google-sheet-api-project
ode_modules\google-auth-library\
If I got promoted I'll give a donate
Sir, how can I get the script code?
hello, i hope you're doing well.
first of all excuse my english if i am not verry clear, i am a french guy😊
Now i have tried to do the same work following you but i am blocked at the installation of exceljs packages.
here is the error :
internal/modules/cjs/loader.js:330
throw err;
^
at tryPackage (internal/modules/cjs/loader.js:322:19)
at Function.Module._findPath (internal/modules/cjs/loader.js:683:18)
at Function.Module._resolveFilename (internal/modules/cjs/loader.js:953:27)
at Function.Module._load (internal/modules/cjs/loader.js:842:27)
at Module.require (internal/modules/cjs/loader.js:1026:19)
at require (internal/modules/cjs/helpers.js:72:18)
at Object. (C:\Users\Ousmane\Desktop\sheets-api-project\main.js:3:17)
at Module._compile (internal/modules/cjs/loader.js:1138:30)
at Object.Module._extensions..js (internal/modules/cjs/loader.js:1158:10)
at Module.load (internal/modules/cjs/loader.js:986:32) {
code: 'MODULE_NOT_FOUND',
path: 'C:\\Users\\Ousmane\\Desktop\\sheets-api-project\
ode_modules\\exceljs\\package.json',
requestPath: 'exceljs'
i run this command --- npm list --depth=0 -- to verify all packages installed
and the result is :
┌──────────────────────────────────────────────────────────────┐
│ npm update check failed │
│ Try running with sudo or get access │
│ to the local update config store via │
│ sudo chown -R $USER:$(id -gn $USER) C:\Users\Ousmane\.config │
└──────────────────────────────────────────────────────────────┘
sheets-api-project@1.0.0 C:\Users\Ousmane\Desktop\sheets-api-project
+-- exceljs@4.0.0
`-- googleapis@39.2.0
apparently the apckage is present but it does not work.
i tried every things but still blocked
please can you give some help.
thanks in advance.
When you install packages make sure your terminal is in your project folder.
Hi ... you´re Ok ?
Sorry, the space where I was recording has gotten too noisy to produce anything, so I had to take a break to find a different solution. New videos should be coming next week.