I have a Google sheet script that extract DATA from URL into a new sheet.
Before i tell you want i need i will explain how the script above work.
after I'm Pasting a URL into a Single Row, after the script finished running, he extracts the DATA i asked him to and save it into a new sheet.
for example: i am pasting 200 URL's, after the script done running he opens me a new sheet with the extracted DATA of the 200 URL's.
If you want to see how does it work , go to the fallowing like and just click on the "GET RESULTS" Button https://docs.google.com/spreadsheets/d/1Wj1BisN6vWMFfjvrtQodeJ0NMKk9nNeG44jyZa4G_O8/edit#gid=958618279
The Problem i'm facing is with Google script timeout limit after 6 minutes. If i'm adding higher number of URL's 1000+ , i am getting a timeout error, the job is stopped , and i need to start again by giving him much lower numbers of URL's.
I looking for a way to help me without the need of me manually copying/pasting the URL's (sitting in front of the computer).
one idea i have is to have a sheet that contains all the URL's i want to extract and a script that will copy/paste 200-300 URL's Automatically after the job above is down. that's how i wont have to sit in front of the computer and do it by myself.
I'm welcome to hear other ideas.
Hi, can help.
Yes it's true that when you have huge amout of links to process you'll recieve execution overtime error during script running.
The only solution is create and using script which remember last succesfully processes/fetched link and resume script work (at next run) from that point.
In spreadsheet can be appeared for ex. such kind info : 100 url from 300 were processed. So in order to get info over all links you need run script few times.
Another variant is set up all via trigger, but suppose it's not option which you are looking for.
Regards, Viktor
Thank you for your invite
I am Ming Yu. I am iPhone/android and backend developer.
I have read your project description and I have very interested in your project. So I applied your job.
I have been doing iPhone/Android app and web programming development for over 6 years. so I have many experiences and resources for mobile and web development.
If you want then I can show share screen my results.
I want to discuss in detail for your job with you.