Hi,
I’m gathering data from a Surveymonkey list, and using Zapier to transfer this into a Excel sheet on by business OneDrive account. Recently, I updated the Surveymonkey list with additional questions, and matched these with columns in my spreadsheet. However, when I try to capture this in my Zap, the question from Surveymonkey appears, but I can’t find the column in the OneDrive spreadsheet. I’ve tried to refresh and edit again, but it still doesn’t work. Any help would be most welcome.
Hi
If all the columns aren’t loading for the Excel spreadsheet then it could be that there’s an issue with the setup of the sheet. The Microsoft Excel app requires workbooks/spreadsheets to be formatted in a certain way, (the column names need to be in row 1, starting in column A) in order for the columns to be leaded in the Zap.
You can learn more about this here: Work with Microsoft Excel in Zaps.
If it’s more that only the newly added columns aren’t appearing, you might need to reselect the workbook and sheet in the Zap, and press the Refresh fields button to get it to load in the new column fields.
Hope that helps to get you pointed in the right direction. If I’ve misunderstood the issue, or you run into any trouble on that do let me know!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.