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?