Getting errors with Convertbox to Excel Spreadsheet

[Leo33]

Your Task History ID

IjU3NjUwNTY4MDYzNDA0MzU1MjZkNTUzMjUxMzU1MTZhNTQzMzBmMzIi_pc

I have an automation to get leads using Convertbox (after filling up a survey) and then I want them to be added to a Google Sheets or Excel sheets. (This is the automation https://connect.pabbly.com/workflow...eDWxdSQIGAVcJelxGBjpUVwd9B0oAewZPCzgOUFhwXj8#)

However, for some reason if I try using Google sheets, I cant find the file within the drive, I have re-created the connection to the drive and it is still not available.
I managed to use One drive and connecting the Excel file and it worked adding a few rows, however, it stopped working and im getting the error: "
The number of rows or columns in the input array doesn't match the size or dimensions of the range."

What can I do?

 

[Preeti Paryani]

Hello @Leo33,

Could you please confirm if you have made any changes to the header of the Google sheet or Excel? This will allow us to better understand the concern and assist you with it.

 

[Leo33]

1. Using google sheets doesnt work, it doesnt fetch my file. I have tried in incognito to regreate the connection and have the drive and document open in different tabs. No luck, Pabbly does not show my google sheet within my google drive.
2. Using excel in one drive, it started working fine but after 4 queries, it stopped working and stsrted showing that error i sent before. I havent made any changes to the headers or the excel file. There is something wrong with the task as it doesnt even show the spreadsheet and tab names, it shows it as "book 1" and "sheet 1", when I configured it the first time it showed the names of both fine, now it doesnt work and wont even show the correct file and sheet names, but the columns headers are being showed correctly

 

[Preeti Paryani]

Hello @Leo33,

Please let us know a convenient time for you to join us over a Google Meet between Monday to Friday, during either of the following time slots:

• 11:00 AM – 1:00 PM IST
• 4:00 PM – 5:00 PM IST

Let us know your preferred time so we can schedule the meeting accordingly to assist you better.