I what to run a process that scrapes Google Search Results and then does stuff with the returned URLs. I’m thinking that I need the list of urls in a Goggle Doc so then I can run a html get module for each. The ultimate goal is to create a word doc, so I don’t need to store the URLs or the Google Sheet beyond the run. What is the best way to do this. Example keep adding to the list then pull the last 10 urls; create new tabs; create a new sheet then delete when done; clear the list and then add rows. Etc?
Hi @Bill_Scully, You can use only one Google Sheet database for it with whatever you need as an input to configure scraping. Then simply use ‘Get Range’ module in sheet. In the module you can also specify the limit. After the getRange module, do your scraping. If you want to remove the row after having finished scraping, just use ‘Clear Row’ or ‘Update Row’ modules with Row Number from the first ‘Get Range’ module. Does that work for you?