Problems copying URLs Extracted With "Get Text" into Google Sheet

[justindward (Justin Ward)]

Hi Everyone,

I’m building an automation that enters names from a Google Sheet into a search, and I want to get the URL of the search results page and enter it into the same sheet.

Right now I have all the UI automation set up in a “For Each Row” activity and it’s iterating through the names correctly, but it’s not copying the URL to the spreadsheet. I’m using Get Text to pull the URL from the browser and then Write Cell, writing to CurrentRow.SMCURL. I know this is probably wrong, but I don’t know what the other options are here.

This seems like it’s probably an easy fix. Any guidance would help.

Workflow:

[justindward (Justin Ward)]

Also, it appears that the URL is copying but into the A1 cell (containing a header for the Last name) every time and overwriting the last value.

[ashokkarale]

@justindward,

We have Get URL activity for this. Just use it inside Use Application browser activity and you should get the URL.

[justindward (Justin Ward)]

Hi Ashoka. thanks for the quick response. The issue isn’t pulling the URL, which is working. It’s writing it into the Google sheet. Do you know which I should use? Write Cell, Write Range, Write Column, etc.? And how should I set it up to write it to the correct column in the current row?

[ashokkarale]

@justindward,

Use write cell activity. Declare a variable to store the index or the iteration and use it in range to make it for dynamic row

[ravindra.reddy33 (Ravindra Reddy Madireddy)]

Hi @justindward ,

You can try using google sheet activities. you need to install a package related to google spreadsheet

Activities - Use Google Spreadsheet