I wonder about this error.
How do I do in order to add columns to the spreadsheet when I got this error?
I dont understand where to specify the spreadsheet columns.
J
Hello,
In order to use Google Sheets you need to have the table column names in the first row of the worksheet. These will show up as text boxes in your flow for you to fill out.
Thank you,
-Stephen
It works when spreadsheet is located in OneDrive, but it is not working with google drive. In fact, the insert row option is not more available for drive.
Ideas?
Sorry you ran into this issue! Insert row for Google Drive is slightly confusing, because in reality it only works for Google Sheets.
We just released a new Google Sheets connector, which you can use. Let us know if that works out better for you.
For any Excel spreadsheet (in Google Drive as well), select the Excel connector. Once you select the Excel connector, you can change the connection to select the underlying connection (Google Drive).
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Chiara Carbone as our Community Spotlight for November…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 560 Super User 2025 Season 2
Tomac 347 Moderator
Expiscornovus 262 Most Valuable Professional