How to Import Data from web to Google Sheets and update automatically

create Google Sheets function to imports data from HTML Source to Google Sheet and makes it update automatically by making trigger to run the function every one hour.
#howto
#how_to
#IMPORTHTML
#Google_sheets
#google_docs
#Automatic_update
:Download the Function TXT file here:

[VeMK]

Thank you so much!! This worked way better and declaring multiple variables was easier than the last script I was using.

[ScottOlsonSacramento]

The tinyURL (/74t8lz) does not seem to work any longer. Can you post an updated link to the function TXT file ?

[AleFdezSilva]

Thank you so much!!! Greetings from Argentina.

[nsciulli]

for some reason for me it's not recognizing sheetName or cellFunction as variables so it won't run

[NyxView]

Insightful!!!! Thanks for sharing this

[ztxdtpp]

Hello,
I need small information please, Can we insert values from salesforce to google sheet on daily basis?
for example on 19th May the record count is 287 in salesforce and this value should be updated in google sheet on 19th May and on 20th May if record count 200 it should be updated in google sheet in next row and like wise. Can this be done??

[MZ-zcot]

I have this message :( TypeError: Cannot read property 'getRange' of null (ligne 6, fichier "Code")

[gabrielinti]

are you from India? I was born in Brazil, I wish I was born in India to be smart, +1 like

[AnkitVijaywargia]

NOT UPDATING DATA!!!

I just used this scrip and the data got populated on first run but since then there is no change in data. I am using 1minute trigger. The data on the source website updates every 3 minutes. Please advise!

[Cocinaconunitaliano]

Thank you! Is it possible to do the same, but import data from a .txt file?

[tonmoy]

great video. though i have integrated my sheets with the sheet Best API tool

[alphashadowgamer]

Is the =importxml also can be work on live update after the script done?

[NyxView]

How to fix below issue:
Error
"Resource at URL contents exceeded maximum size" while import_data in google sheets?

[athawanproductions]

How can do the same procedure to import json data into Google sheet

[sharma]

Sir could you please guide me to create excel auto update table about bestselling books rating on specific category say personal finance. 🙏🏾

[waleedkhan]

Can i use the same method to import data from Redash to Google sheets?

[rosmarydominguez]

Do you know how to record the data, to have a daily record, I've used the function but I need to have a record like 23/06 1000 transactions, 24/06 1250 transactions.

[TakeTheMTwain]

You didn't show where that recorder is coming from.

[dimitrioschantzis]

Great video, I apply the importxml function to Google Sheets and other times it works and other times (without changing anything) it gives me #N/A into cell. What can I do? Thank you very much