Why can't I find Google Sheets as a data source option in Azure Data Factory?

Jesse 1 Reputation point

Why can't I find Google Sheets as a data source in Azure Data Factory? I created the linked service, tested the connection and it works. Then when I go to a pipeline and attempt to use it as a source, it doesn't show as an option.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,948 questions
{count} votes

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA-MSFT 83,306 Reputation points Microsoft Employee

    Hello @Jesse ,

    Thanks for the question and using MS Q&A platform.

    This Google Sheets connector is supported for the following capabilities:


    When transforming data in mapping data flow, you can read resources from Google Sheets. You can only use an inline dataset as source type.


    For more details, refer to Transform data in Google Sheets (Preview) using Azure Data Factory or Synapse Analytics.

    Hope this will help. Please let us know if any further queries.


    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is jhow you can be part of Q&A Volunteer Moderators