Description of the issue:
I have an Excel sheet I created with Bardeen. The links I was able to pull from my scrape are encoded but when they are pasted into a browser they resolve to the proper url. I want to take these encoded links, open them in a browser, resolve the URL, copy it and paste it into a new column in my Excel sheet. I canât figure out how to do this as the data I want to pull from the browser is not on-page but is in the address bar instead.
Error message (if aplicable):
Please paste the error message below:
There are no error messages
Steps to reproduce this issue:
I created a scraper linked to an Excel sheet and ran the scraper on the restaurant listings on this page: Things to Do in Napa Valley | Arts, Music, Outdoors, Shopping & Spas
Then I ran a deep scraper on those results to get data on each listing including their website address, socials and a link to their featured image.
The problem is that each of those links is encoded - if I paste the link into a browser it does resolve to the proper place. I want to get the resolved links and place them in my Excel sheet.
Here an example:
Which resolves to this:
Bardeen version: ____
3.1.0
Link to Playbook or Autobook (if applicable):
Video recording or screenshots (optional, but recommended):
(Upload your files here)
You can also embedd a loom video or gif.
Hi Shelley,
It looks like the action you are looking for is called âGet redirected URLâ:
You can create a simple automation to address your task: get table from google sheets > get redirected URL of every row > update google sheet rows.
Related help guide: https://support.bardeen.ai/hc/en-us/articles/29931926537613-How-to-Integrate-Google-Sheets-with-Playbooks
Let us know if you have any other questions!
Victoria
Customer Support - bardeen.ai
Knowledge Base https://support.bardeen.ai/hc/en-us
Explore | @bardeenai | Bardeen Community
Thanks so much for the reply, Victoria!
I tried this out and did get it to work but still have some questions âŚ
First, I can get this to work on a single table row of urls in Google Sheets - this works great. But, when I try to redirect and replace all of the urls in all of the columns nothing happens. Perhaps I have set it up wrong? For Get redirected url I selected Get table from All fields. for the Update Google Sheet rows command I placed Get redirected url: URL in the Update rows with data field for the appropriate columns. (Shared Playbook Template)
Second, I like to work primarily in Excel in OneDrive and there is no real equivalent of âupdate google sheet rowsâ for Excel ⌠I selected 'Add or update a row to Microsoft Excel" and set things up exactly the same way as I did in the google sheet and what happened here was that all of my columns got deleted except for the one with the URL I wanted to fix the URL in. (Shared Playbook Template)
property=
Explore shared playbooks that you can start automating your work with just one click.
www.bardeen.ai
So, for now I can run in Google Sheets and run the automation multiple times but I would love to be able to run in Excel and only once per sheet.
Hi Shelley,
- I see you selected âAll fieldsâ for converting links. Unfortunately it does not work this way, the action can convert by columns. Please re-connect the Get redirected URL action to one column of your sheet and modify the Update rows action accordingly. If you have 3 columns with links for converting, Iâd recommend you to run the automation 3 times, one for each column. Thatâs just to avoid overcomplicating the building process for you as beginner.
- Are there any duplicate links in your excel? I am looking at the automation you shared and it seems to be configured correctly.
Looking forward to your reply.
Victoria
Customer Support - bardeen.ai
Knowledge Base https://support.bardeen.ai/hc/en-us
Explore | @bardeenai | Bardeen Community
Hey there Victoria, I tried all columns because you instructed me to âget redirected url of every rowâ ⌠I clearly misunderstood your intent. Everything is working fine in Google sheets but still doesnât work in OneDrive.
Thank you!
Travel safe,
Shelley Montreuil
CEO - trippl
902-303-9449
Prince Edward Island, Canada
trippl.ca
Book a Demo
Made with Scribe
Shelley,
I think I finally found the problem with your excel automation. It appears that you are processing Website column, but on step for updating rows, you have linked everything to Link column. Please try using Website column on both steps, it should work.
Let me know how it goes!
Victoria
Customer Support - bardeen.ai
Knowledge Base https://support.bardeen.ai/hc/en-us
Explore | @bardeenai | Bardeen Community
