AppFlow SourceFlowConfig ConnectorType for Google Sheets?

Question

What's the AppFlow SourceFlowConfig ConnectorType for Google Sheets?

When I launch a CloudFormation stack with the following AWS::AppFlow::Flow resource, I get the following property validation failure:
```
#/SourceFlowConfig/ConnectorType: GoogleSheets is not a valid enum value
```
```yaml
Resources:
  Flow:
    Type: AWS::AppFlow::Flow
    Properties:
        DestinationFlowConfigList:
          - ConnectorType: DynamoDB
            DestinationConnectorProperties: {}
        FlowName: Flow
        SourceFlowConfig:
          ConnectorType: GoogleSheets
          SourceConnectorProperties: {}
        Tasks: []
        TriggerConfig:
          TriggerType: Event

Answer

I think that the issue is that DynamoDB isn't supported as destination for Google Sheets.

You can set either RDS for PostgreSQL or Redshift as destination.

You can find the full list of supported destinations [here](https://docs.aws.amazon.com/appflow/latest/userguide/connectors-google-sheets.html#google-sheets-destinations)

Plus you also have to provide the connector properties, as without them you won't be able to do anything
![Configure flow](/media/postImages/original/IM-VLtiNiXRceUsArfxVG8TQ)

AppFlow SourceFlowConfig ConnectorType for Google Sheets?

Relevant content