web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Google Drive error

(0) ShareShare
ReportReport
Posted on by

I wonder about this error.

 

How do I do in order to add columns to the spreadsheet when I got this error?

 

Google Drive error.JPG

I dont understand where to specify the spreadsheet columns.

 

J

Categories:
I have the same question (0)
  • Stephen Siciliano - MSFT Profile Picture
    on at
    Re: Google Drive error

    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

  • Community Power Platform Member Profile Picture
    on at
    Re: Google Drive error

    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?

  • Community member Profile Picture
    on at
    Re: Google Drive error

    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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 560 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 347 Moderator

#3
Expiscornovus Profile Picture

Expiscornovus 262 Most Valuable Professional

Last 30 days Overall leaderboard