Import Excel Data to Google Sheets Automatically Using Google Sheets API & NodeJS
Вставка
- Опубліковано 5 вер 2024
- Learn how to automatically import Excel data to Google Sheets with NodeJS using Google Sheets API.
Node JS Google Sheets API Tutorial - Part 2
#GoogleSheets #API #nodejs
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.
OMG Amazing!!!! Where is the part 1 of the tutorial???
ua-cam.com/video/MiPpQzW_ya0/v-deo.html
Thank you very much, you are very good teacher. Very clear explanations. GBU
Thanks for the videos!!!!!! You automate my life
Please do more Google Docs videos ;]
will it be able to copy the template if the template has formulas ?
You are a life saver!!
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.
With a +50.000 rows, 5 columns Excel file will be this method efficient ? Excellent video !
It should be fine.
You are super! How am i able to import columns that only matches the labels (of first row) in my spreadsheet?
Amazing!!! Thank you very much for your channel!!!
excellent video, Thank you
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.
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) ?
thanks a lot 🥰❤
Hi please can you share link for part 1 how to download node.Js
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.
When you install packages make sure your terminal is in your project folder.
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?
hello! how can i trigger this code by events on google sheets or excel. Can you help me pls
How to run this async function gsrun repeatedly? tried with setinterval but showing login error.
As you have fetched the whole row.I want to fetch just data column wise.How to do that
in part1
Create videos on Google Glide ... please!
Is there a reason why you wouldn't use batchUpdate rather than update?
Hi can we capture facebook leads in google sheet pls make a video on that
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 ua-cam.com/video/MiPpQzW_ya0/v-deo.html
How about if I import csv file?
If I got promoted I'll give a donate
How to update automatic in google sheet through this script
Sir, how can I get the script code?
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.
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.