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?
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?
I've already tried that...set to "Plain Text" before the new row was appended, but the leading 0 was still removed.
I've already tried that...set to "Plain Text" before the new row was appended, but the leading 0 was still removed.
Weird! Here's a gif of it working for me as a data point:
Weird! Here's a gif of it working for me as a data point:
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.
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.
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?
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.