#2538-Google sheet data mapping.
Ahammed Junaid
Hai. When we link google sheet with a whatsapp flow and fill the data, in whatsapp flows there can be non mandatory fields and user may skip it. So when we get this data in google sheet, data is just filling next cell, not filling as per the head. For example there are three questions. Name, Location(non mandatory), contact. First user fill 3 fields. Second user skip the location. Then iphone number will fill at second column instead of keep it blank and fill on 3rd column. How can we map it properly?
Dear Ahmed Junaid,
Currently, we do not support column mapping for WhatsApp Flow data in Google Sheets. The data submitted by users is saved directly to the sheet in its default structure.
At this time, there is no available workaround for this limitation.
Thank you.
Best regards,
Kamrul Hasan
The Google Sheets mapping for WhatsApp Flow data has been fixed. Data will be inserted into Sheets in the order defined by your flows form and any empty fields will be saved as null.
Woow.. great.. for that next time when we create a flow, is there any extra step we need to do from our side?