I am attempting to use a Read Cell activity within GSuite Application Scope to read a cell from a Google Sheet and use the output of that cell as the StartingCell for a Write Range activity. The cell referenced within my Read Cell activity contains a formula, but the text reads, “A141” (with the double quotes, to be used as a cell reference) for example. I want to use that output as the StartingCell for my Write Range, so that I don’t have to manually update the starting point each time I run my Sequence.
Here is what I’m trying to do, where “spreadsheetID” is the Google SheetID, sheetIDListofONLC is the name of the tab within the Google Sheet, ONLCircles is the data that is to be written, and Testing2 is the cell reference (“A141” as mentioned above).
When I run the sequence, it gives me this error:
Can anyone help me figure out how to use a variable to pass the StartingCell instead of manually updating the StartingCell with each run?
Additional Information: Sequence for what I am attempting to do: