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

Question

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.

Answer 1

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 or upvote 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