You can create a Google Drive Destination Connector to write CSV files (by default) or JSONL files to a Google Drive folder using your Google account. We do not currently support Shared Drives.
To set up this Destination Connector, your Google account will need access to the Google folder you are connecting to.
Supported file formats: We only write to CSV or JSONL files. We cannot write to a Google Sheet using a Google Drive Connector. To write to a Google Sheet, please set up a Google Sheets Connector.
If you have multi-factor authentication enabled for your Google account, you may need to recreate the Destination Connector when the authentication expires. Re-authentication for existing connections is coming soon.
Google Drive Folder URL
Google Account Username and Password
Creating a Google Drive Destination Connector
Step 1: Click New Connector.
Step 2: Under the System prompt, click Google Drive.
Step 3: Provide a Connector Name.
Step 4: Select Destination Connector.
Step 5: Provide the Folder URL.
Building the Schema for the Destination Connector
Use the schema designer to build the output schema for this Destination Connector.
Provide a field name for the output fields. These names will be used as the column headers or field names in the output file you are writing to.
Define the type of each field. The field types will be used to enforce rules when you send data to this Connector.
Check this box if the field is nullable. If the field is not nullable, you will be required to provide values for this field when sending data to this Connector.
Deletes the field.
Adds another field to the schema.
Step 1: Click Add Field for each additional field required in the schema.
Step 2: Select Create Schema once you have built the schema.
The schema cannot be changed after saving the Destination Connector, so please confirm it is accurate before proceeding.
Output File Format
By default, this Destination Connector writes CSV files, and each Osmos Pipeline run produces a new file. If preferred, you can choose to change the output to JSONL files instead of a CSV files.