• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $149 (🏆Lifetime Access) - View offer

Issue connecting to Excel and adding row to table

adam0

Member
I have a workflow with a webhook trigger pulling a form response and moving the data into our CRM, I want to also put this data in an Excel table but when I connect Excel to Pabbly I am running into an issue that I am not finding any discussion on so I am making this post.

So when I connect to Excel, I can pull down a list of all of my Workbooks, but no matter what workbook I select I cannot see any worksheets or tables I just get this screen:

1699644647754.png


I do not know what the Drive ID would be nor is that mentioned in any of the tutorial videos etc.

I tested this step on Zap and was able to see all the table columns no problem so I am not sure what the issue is, any help would be much appreciated.
 

ArshilAhmad

Moderator
Staff member
Hi @adam0,

Please try using the 'Search File in My Drive' action event to obtain the Drive ID, and then enter that Drive ID into the 'Add Row to Worksheet' action event. This should provide you with the necessary fields.
1699646059718.png


Once you have entered the Drive ID into its designated field, you can delete the 'Search File in My Drive' action step.
 

adam0

Member
Hi @adam0,

Please try using the 'Search File in My Drive' action event to obtain the Drive ID, and then enter that Drive ID into the 'Add Row to Worksheet' action event. This should provide you with the necessary fields.


Once you have entered the Drive ID into its designated field, you can delete the 'Search File in My Drive' action step.
Yes, that worked thank you.
 
Top