Zap to check site status, return value to Google Spreadsheet, run loop until all sites checked

Hi @slalonde00 

Check out this topic about creating a Loop with a GSheet:

ok, but how do i check if a website is still working ? do we have any tools for that or should i just do a javascript script that check for a website response status ?

Hi @slalonde00 

If you know JavaScript, then a Code step can be used in the Zap: https://zapier.com/apps/code/help

Otherwise, you can search the available Zaps here: https://zapier.com/apps

aight i managed to create a loop, but now when i test the updating row action it gives me this Error : 

There was an error writing to your Google sheet. Unable to parse range: 'Entreprises_GA_20210913'!À Vérifier

how do i fix this ? My lookup row action return me the row i want, but it seems it can’t update the row.

i have editor permission on the google spreadsheet, no name of worksheet or spreadsheet was changed as far as i know and reselecting the spreadsheet did not helped. Also i tried to remove all of the protection from the whole worksheet, but it did not work either.

Hi @slalonde00 

Please post screenshots of how your Zap steps are configured where the error is happening.

here is the zap in question : https://zapier.com/shared/caba0f261f9043664c12635faf166ac7957f84b4

Hi @slalonde00 

also wanted to know how do i run it on the spreadsheet, because it is now turned on and i’ve yet to see any change to the spreadsheet.

ok. so my zap seems to only work for the first time, which is fine. So all i need to know is how to run it on the spreadsheet @Troy Tessalone 

@slalonde00 

Please post screenshots of how your Zap steps are configured.

you mean those : 

basically i only change the cell named “Status Site Web” and keep the rest of the data as is. The empty data are normal as they don’t have anything in them atm.

@slalonde00 

This needs to be a Row ID which is a numerical value.

you mean on all the edited value or just on this one ? also i want to update 1 row in a loop until it goes through all the rows.

@Troy Tessalone ok, so now i does overwrite the right cell, but now it just does not cycle through all the cell, it only does the 1st cell and doesn’t update the others. 

@slalonde00 

Please post screenshots of all your Zap steps, thanks.

Might be worth revisiting this video...

Check out this topic about creating a Loop with a GSheet:

• Video | Creating a looping Zapier automation using webhooks