Google Drive logo
→Google BigQuery logo

Ready-made Workflow

Load new Google Drive CSV files into BigQuery

Connect Drive and BigQuery using a Google account registered for BigQuery OAuth testing. Select a dedicated Drive folder and an existing table with a compatible schema. Use the same Google Cloud project in Project ID, Configuration → Destination table, and Job reference. After the first poll, upload a new UTF-8 CSV up to 5 MiB with one header row. FastHook downloads the File and submits an append job with an ID derived from the Drive file. Check the job status in BigQuery to confirm the load.

Use this templateCreates a new Draft · no credentials copied

What gets copied

The working graph, not another user's secrets

FastHook recreates every Step, route, field mapping, and setting with new IDs in your workspace.

Step 1 · Google Drive · Trigger

New file in Google Drive

Emit newly created files in the selected Google Drive folder. Direct children only; existing files moved into the folder are not new files.

Step 2 · FastHook

Only CSV files

Continue only when the configured conditions match the incoming record.

Step 3 · Google Drive

Download CSV File

Download a binary Drive file as inline Base64 URL data or a secure stored-file reference.

Step 4 · Google BigQuery

Start a CSV load job

Load an authorized File into a BigQuery table using a multipart load job.

Before activation

Connect your accounts in the Draft

1

Google Drive

Connect your own Google Drive account and review the provider settings used by this Workflow.

2

Google BigQuery

Connect your own Google BigQuery account and review the provider settings used by this Workflow.

Explore connected apps

Questions

Template FAQ

Does the template copy someone else's credentials?

No. FastHook creates a disconnected Draft. Connect your own Google Drive, Google BigQuery accounts before activation.

Can I change the Steps and mappings?

Yes. The copied Workflow is an editable Draft. Review every Step, input, mapping, and route before you activate it.

What is copied into my workspace?

FastHook recreates the Trigger configuration, Action Steps, routes, and mappings with new IDs. Provider accounts, credentials, and secrets are never copied.

When does the Workflow start running?

Only after you connect the required accounts, finish the configuration, and explicitly activate the Draft.