Leading Zeros are missing when we get data from a spreadsheet

PatrickIgnoto

Link to WF and launch: https://account.wrk.com/v2/dashboard?wrkflow=58375&panel=launches&client_id=5783

I know this is a common issue but I'm wondering what the wrkaround should be for this. I have my "Retrieve data from a row in Google Sheets" pulling everything as text. The spreadsheet has the value for PCC ID as '05440

But when the action executes, it returns the PCC ID 5440.

These IDs aren't a standard number of digits so I can't use the padding WrkAction. What can I do?

WA-24: Retrieve data from a row in Google Sheets
completed with Success at 10:48:57 AM
Execution ID: 2be5e078-52d5-4e56-bf4d-e07d646619af

Comment: Get data from Row index
Inputs
Roster List: [redacted]
Roster Sheet Name: Nursing Home
Row Index: 9
Google Sheets connected account: Patrick's Sheets
Row number: 9
Spreadsheet link: [redacted]
Sheet name: Nursing Home
Outputs
Name: Gregory 'Greg' Davis
PCC ID: 5440
Carelogic ID: 91254

Nick

Hey Patrick,

The easiest workaround is to add a real character (like "ID") before the ID that you can remove after you pull the ID. Another option, if possible would be to store the info in Data store where you will have more control over the data staying as intended.

The changes here are happening in the Google Sheets API before we even see the info so we are unable to make changes in the bots to accomodate for this