"Append data to spreadsheet" is missing "Sheet name" field

App Building
1

  • Goal: Append data to 2nd sheet in a Google Sheets document

  • Steps: Trying to specify the Sheet Name of the second sheet, so the data does not get added to the first sheet. In discussions such as this one or this one, the "Sheet name" field is clearly missing, but the field seems to be missing in Retool at the moment. I don't have the option to specify a sheet name, no matter what I try.

  • Details: See both attachments for a difference between the screenshot someone else took (containing a "sheet name" field) and my own screenshot (not containing a "sheet name" field).

  • Screenshots:

    someones_screenshot
    someones_screenshot482×708 27.6 KB

    my_screenshot
    my_screenshot992×1002 46 KB

Can someone tell me why the field is missing now, or how to use a different sheet than the first sheet?

Thanks very much!

2

Sorry, I wrote that wrong and don't know how to edit my post.

I meant to say.. in the two linked examples, the field is clearly present.
But in my screen it is missing.

Why?
Or how can I get around this and specify the sheet name?

Thanks!

3

Hi @A_USA,

Thanks for reaching out! I haven't been able to reproduce this issue :thinking: Do you see any browser console errors? Does it also happen in an incognito window?

For testing, is it also missing from the other query types (delete, update, etc)? Could you share a screenshot of the resource set up as well - what authentication type did you select?

I'd also be curious what version of Retool you're using (you can see the version # by clicking the bottom right corner ? button)

If you urgently need a fix, I recommend trying to connect to the Google Sheets API via our generic rest api integration in place of the Google Sheets integration until we sort this out.