Can I keep article URLs unchanged when sending them to Google Sheets?
Status: Open · Asked by Peter on · 0 views
I am looking at Pabbly Connect for keeping a list of Ask Ayurveda articles in Google Sheets. I would like each row to contain the article title and its original URL.
For example, this is our yoga for stress relief article. The address has a numeric ID before the title. Other article addresses in the list also have repeated hyphens, so I would like to copy the full address without rebuilding it from the title.
Can I map the URL directly into a Google Sheets cell and keep it clickable, or does that need a separate formatting step? I have not built the workflow yet. I am checking how to handle this field before setting it up.
Hi Peter,
Thanks for reaching out!
Yes, you can map a URL value directly from your trigger or a previous step into a Google Sheets cell in Pabbly Connect. You do not need to rebuild the URL from the title — you can insert the full address as a mapped field, and it will be written to the cell as-is.
A couple of things worth keeping in mind:
- Whether the URL appears as a clickable link depends on Google Sheets itself, not Pabbly Connect. Google Sheets will typically auto-detect and hyperlink a plain URL in a cell.
- One thing to watch for: if any value you map into a Google Sheets Append Values action contains double quotes ("), that action can fail, because the action formats values internally as "value1","value2" and embedded quotes collide. Standard URLs like your example won't have this issue, but if you ever map content containing double quotes, insert a Text Formatter (Pabbly) Replace Text step to replace the double quotes before writing to the sheet.
Since you haven't built the workflow yet, once you set up your trigger and Google Sheets action step, you'll be able to click into the cell field and pick the URL value from your trigger's mapped output.
If you run into any issues while building it, feel free to share your workflow URL and we'll take a closer look.