Hello,
I’m trying to scrape a website. When I manually put in the URL, it will work. But when I get the URL from Google Sheets, it will fail.
Here’s the manual URL, it works.
But when I parse it from Google Sheet, it will fail. I’ve already made the google sheet free text, there’s no links in it.
The workflow is quite straightfoward.
I’m using the cloud version of n8n.
Hello and welcome to the community!
You’ve got 36 items incoming. Are you sure all of them contain valid urls?
Please put your workflow between a pair of triple backticks for the workflow to render properly.
```
The WF JSON goes here
```
Please also pin data on Google Sheets node before copying the WF. It is very likely that the issue stems from data.
Thank you Olek.
I’ve not figure out how to filter the spreadsheet yet, but that shouldn’t affect the workflow as I’m only parsing over URL2, and there’s only 1 entry there. Example below.
I’m not sure what you mean by a pair of triple backticks, I’m definitely doing it wrong because it didn’t work.
Appreciate your help.
Well, it may fail on the 2nd row where URL2 is empty. The node tries to process all incoming items before moving on to the next node.
That was about posting the workflow to the forum so that it renders nicely and can be used to study your case.
Click the </> button in the formatting toolbar. It will create a placeholder for you.
Check this short guides on how to copy a workflow with pinned data and paste it on the forum.
You’re right Olek, after removing the data from columns A (many rows) it went through. The workflow works now, thank you!
P/s Also fixed how the workflow is showing in this thread.
Glad to hear that!
Would you mind marking my post that helped to resolve the issue as a 
Solution?
This will close the topic and help future readers should they come across the similar situation.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
