Google Sheet column headers

[katalystjay]

Your Workflow URL

https://connect.pabbly.com/v2/app/workflow/share/AUlTYVUCVzQETlI4VjMHIFhMCg4JUAlrVUwIGgYJXCRVG1I5B0YMZl8TByVTFARlAElSOA5SAjtfSwIGVwEDcFRNVGhTUFAqBksEfwBjCToBX1N7VTQ#

Consent to Access & Modify

I authorize Pabbly Support to log in to my account and make changes to the specified workflow for troubleshooting.

I have a feed from a google sheet. In this sheet I have a range of column headers setup, and a set of this columns have dates as the header. I then populate row by row data (in this instance client name, email and amount due on each date). I can send this data to pabbly web hook but then I get stuck extracting to create invoices. What I need to be able to do is have an array created from the data so I can run an iterator to create an invoices (using Xero) for each date that has a payment amount. There seems to be no way to extract the column header if I setup a manual set of Xero tasks. I have tried receiving the raw data from rather than simple however then trying to split that with a text formatter to create an array only ever returns a full set of simple data.
How can I access those headers (as I want to use them as the invoice due date) along with the payment amount for the client on each row?

 

[Preeti Paryani]

Hello @katalystjay,

Thank you for explaining the use case in detail.

Please note that this is not possible in the current setup, as column headers are treated differently from row data and cannot be dynamically accessed or iterated in the same way as normal values. Due to this limitation, headers (including date-based headers) cannot be extracted and used directly as invoice fields such as due dates.

To better understand your requirement, could you please clarify:

• Why the dates have been added in the column headers?
• Are these dates meant to generate multiple invoices (one per date), or are they intended to be used within a single invoice?

We also request you to please share a short screencast explaining the Google Sheet structure and how the data is being populated. This will help us understand your use case clearly and guide you on how the sheet can be restructured to achieve the desired automation.

Once we have this information, we will be able to suggest the best possible approach.