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

Jesse 1 Reputation point
2022-10-31T14:13:56.89+00:00

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.
7,175 questions
{count} votes

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA-MSFT 59,331 Reputation points Microsoft Employee
    2022-11-01T07:15:12.533+00:00

    Hello @Jesse ,

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

    This Google Sheets connector is supported for the following capabilities:

    255887-image.png

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

    255946-image.png

    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
    0 comments No comments