Feb 04, 2023 09:11 PM
Feb 04, 2023 09:33 PM
Hm, if, in Google Sheets, I set the format of the column to "Plain Text", new rows that get created in Sheets show up as "030", so perhaps you could try that?
Feb 04, 2023 09:42 PM
I've already tried that...set to "Plain Text" before the new row was appended, but the leading 0 was still removed.
Feb 05, 2023 10:09 PM
Feb 07, 2023 09:38 AM
Interesting! Which automation are you using? Yours seems to be behaving differently than mine not only in the fact that the data seems to be getting transcribed correctly. It seems you have a bunch of blank rows already populated (ie rows 2-15+) and your action is correctly inserting in the first available slot, however, with the one I am using, if there are a bunch of blank rows, it will still create a brand new row at the bottom.
I am using the built in "append a new row to a spreadsheet" action.
Feb 08, 2023 01:49 AM
I'm using the same action actually, here's a link to the base
Lemme know if you could use any more help testing stuff out; this feels like one of those puzzles that's going to be slightly frustrating to deal with heh
May want to open a support ticket too?