I am creating a zap that takes data from a Google Forms-linked spreadsheet and uses GPT to draft an automated email reply to the form users.
I want to build my prompt in reference to multiple cells in that spreadsheet. Using Zapier’s drop down menu in the prompt builder, I am able to refer to text in newly generated rows of the specific columns of the spreadsheet. However, I cannot figure out how to include text from one of the header cells.
For example, I may want to build a GPT prompt like so: “Give feedback on the following response to the question <STATIC column header cell containing the question>. The response is as follows: <New response row in question column>.” How do I refer to the column header?