How to Connect Snowflake to Cloud2Sheets

  1. Create OAuth Integration in Snowflake

    • Log in to your Snowflake account

    • Open a Snowflake worksheet and run the following command:

      CREATE SECURITY INTEGRATION "Cloud2Sheets"
  TYPE = OAUTH
  ENABLED = TRUE
  OAUTH_CLIENT = CUSTOM
  OAUTH_CLIENT_TYPE = 'CONFIDENTIAL'
  OAUTH_REDIRECT_URI = '<https://script.google.com/macros/d/1KTU84SW3bKTO0YL6KRe9AqU_BSM0ngTfzv5zzrK2UjQC6zj9Z5fdoj7_/usercallback>'
  OAUTH_ENFORCE_PKCE = TRUE;

    • After creation, run these commands to get your credentials:

      DESCRIBE SECURITY INTEGRATION "Cloud2Sheets";
SELECT SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('Cloud2Sheets');

    • Save the Client ID and Client Secret

  2. Connect in Cloud2Sheets

    • Open Cloud2Sheets in Google Sheets

    • Click "Connect" in the sidebar

    • Click the "+" button to add a new connection

    • Select "Snowflake"

    • Enter a name for your connection

    • Provide your:

      • Account Identifier (e.g., xy12345.us-east-1)

      • Client ID

      • Client Secret

    • Click "Connect to Snowflake"

    • You'll be redirected to Snowflake to log in

    • Select your warehouse and role

    • Click "Test Connection" and then "Save Connection"

How to Connect Supabase to Cloud2Sheets

  1. Get Your Supabase Credentials

    • Log in to your Supabase dashboard

    • Go to Project Settings

    • Under "Project Settings" > "API", find:

      • Project URL

      • anon/public API key

      • JWT secret

  2. Connect in Cloud2Sheets

    • Open Cloud2Sheets in Google Sheets

    • Click "Connect" in the sidebar

    • Click the "+" button to add a new connection

    • Select "Supabase"

    • Enter a name for your connection

    • Provide your:

      • Project URL

      • API Key

      • JWT Secret

    • Click "Test Connection" and then "Save Connection"

How to Connect MongoDB to Cloud2Sheets

  1. Get Your Connection String

    • For MongoDB Atlas:

      • Log in to MongoDB Atlas

      • Click "Connect" on your cluster

      • Choose "Connect your application"

      • Copy the connection string

    • Replace <password> with your actual database password

  2. Connect in Cloud2Sheets

    • Open Cloud2Sheets in Google Sheets

    • Click "Connect" in the sidebar

    • Click the "+" button to add a new connection

    • Select "MongoDB"

    • Enter a name for your connection

    • Paste your connection string

    • Click "Test Connection" and then "Save Connection"

Would you like me to expand on any of these sections or add more specific details to any part?

PreviousHow to Connect Supabase to Cloud2Sheets