Google Drive Data Warehouse
Panoply allows you to easily combine Google Drive data with hundreds of sources
Data sources commonly paired with Google Drive
Google Sheets
Files
Google Analytics
Analytics
Amazon S3
Services
Salesforce
CRM
Google Ads
Ads
MySQL
Databases
Facebook Pages
Social
Zendesk
Customer Support
Bing Ads
Ads
Asana
Project Management
Facebook Posts
Social
Campaign Monitor
Marketing Automation
Chargebee
Accounting
Harvest Forecast
Project Management
Lever
CRM
HubSpot
CRM
PostgreSQL
Databases
MongoDB
Databases
Facebook Ads
Ads
Shopify
Ecommerce
JSON
Files
Microsoft Excel
Files
Twitter
Social
BigQuery
Data Warehouses
CSV
Files
Google Search Console
Analytics
Instagram for Business
Social
LinkedIn Ads
Ads
Stripe
Payment Processing
Xero
Accounting
BigCommerce
Ecommerce
Twitter Ads
Ads
WooCommerce
Ecommerce
Amazon Marketplace
Ecommerce
PayPal
Ecommerce
Payline
Ecommerce
Marketo
Marketing Automation
Intercom
Sales
Amazon DynamoDB
Databases
AppsFlyer
Mobile
Delighted
Customer Support
Elasticsearch
Databases
Google Cloud Storage
Cloud Storage
MailChimp
Marketing Automation
Microsoft SQL Server
Databases
Pardot
CRM
Redshift
Data Warehouses
Twilio
Developer Tools
Upload Data
Files
Wordpress
Databases
GitHub
Developer Tools
Google Analytics Ecommerce
Ecommerce
Zoho CRM
CRM
Tray.io
Services
Jira
Project Management
NetSuite
Accounting
Quickbooks
Accounting
SFTP
Services
Square
Payment Processing
AdRoll
Ads
AfterShip
Retail
Amazon Aurora PostgreSQL
Databases
Amazon Cloudfront
Services
Amazon Kinesis Firehose
Services
Apple Search Ads
Ads
Autopilot
Marketing Automation
Azure Blob Storage
Cloud Storage
Braintree Payments
Payment Processing
Branch
Analytics
BranchTrack
Sales
Codat
Accounting
Contact Pigeon
Marketing Automation
Contentful
Services
Crashlytics
Developer Tools
Criteo
Retail
Customer.io
Marketing Automation
Desk
Sales
Drip
Ecommerce
Eloqua
Marketing Automation
Enchant
Customer Support
FormKeep
Marketing Automation
Freshdesk
Customer Support
Front
Project Management
GitLab
Developer Tools
Google Cloud SQL MySQL
Databases
Google Cloud SQL Postgres
Cloud Storage
Harvest
Project Management
Help Scout
Customer Support
IBM DB2
Developer Tools
Iterable
Marketing Automation
Klaviyo
Ecommerce
Magento
Ecommerce
Mailjet
Marketing Automation
MariaDB
Databases
Mavenlink
Project Management
Optimizely
Marketing Automation
Oracle Database
Databases
Particle
Services
Pinterest
Social
Pipedrive
Sales
Pivotal Tracker
Project Management
QuickBase
Developer Tools
Recharge
Payment Processing
Recurly
Payment Processing
Referral SaasQuatch
Marketing Automation
Sailthru
Marketing Automation
Salesforce Marketing Cloud
Marketing Automation
Selligent
Marketing Automation
SendGrid
Marketing Automation
Sendwithus
Marketing Automation
Shippo
Ecommerce
Sparkpost
Marketing Automation
Spree Commerce
Ecommerce
Taboola
Ads
Trello
Project Management
Urban Airship
Services
Vero
Social
Webhooks
Developer Tools
Zapier
Services
Zendesk Chat
Customer Support
Zendesk Sell
CRM
Zuora
Services
Dropbox
Files
Heroku Postgres
Databases
Modernizing Google Drive
What is data integration?
Benefits of a data warehouse
Your Google Drive data warehouse
Panoply makes your Google Drive data accessible
so you can analyze itExpected Google Drive Data
The Google Drive data source allows you to import data from files stored in your Google Drive account. Panoply supports, various files types including character-delimited files (CSV, TSV), JSON, plain text files, and Microsoft Excel files. Archive-type files like .tar and .gzip are also valid, provided that they contain the aforementioned supported files. eFor file sources that support structured or semi-structured data, like CSV or Excel files, Panoply uses the first row of their data as the columns of their target table. Any rows after that become the records. Sources that contain nested data, usually JSON files, have their nested data extracted and moved to their own tables with foreign keys provided. Lastly, archive files are decompressed, and then their individual files processed accordingly.