Why Can't PipeDream Recognize the Header Row in Google Sheets When Spreadsheet ID is Set Through Custom Expression?

Bugs
1

This topic was automatically generated from Slack. You can find the original thread here.

There is a bug with the Add Single Row for Google Sheets step.

If you set the Spreadsheet ID through custom expression, PipeDream is not capable of recognizing the header row.

I am attaching two screenshots. One is with the header row disabled, where everything works. The second is with the header row enabled, getting an error message.

image.png
image.png922×769 60.9 KB

image.png
image.png922×769 51.6 KB

2

Yea we don’t currently interpolate custom expressions for additionalProps(), which is what is powers the parsing of the headers row

3

In theory if the spreadsheet ID is different per execution (which is why you’d need to reference dynamically), then the header values would likely be different, right?

4

So you’ll need to configure manually, like in your first screenshot