Tutorials
TUTORIAL
How to Connect Google Sheets to Stripe
August 16, 2022 • By Felix Zumstein
Like many business owners, I handle all my invoices via Stripe. Stripe’s dashboard greets you with a bunch of charts and numbers: USD Balance, Gross volume, successful payments, etc. However, one of the numbers I am most interested in is the volume of outstanding invoices. This number tells me how far off my booked revenues are from the actual revenues: one of the lessons you learn early on is that a dollar only counts once...TUTORIAL
How to Connect Google Sheets to SQLite
August 10, 2022 • By Felix Zumstein
This tutorial shows you how to query a SQLite database from Google Sheets with Python and xlwings PRO. SQLite is an open-source, file-based database that’s very powerful yet super easy to set up. The Litestream project has further enhanced SQLite’s capabilities, allowing you to continuously stream database changes to an S3-compatible storage. This gives you the power to restore your SQLite database to a specific point in time, a feature that was previously reserved to...TUTORIAL
How to Connect Google Sheets to SQL Server
August 10, 2022 • By Felix Zumstein
This tutorial shows you how to query a SQL Server database from Google Sheets with Python and xlwings PRO. SQL Server is Microsoft’s flagship database product and is widely used in the corporate world. This tutorial concentrates on querying a SQL Server database directly from Google Sheets. This saves you from the manual and error-prone tasks of having to export data from SQL Server into CSV files, only to import them again into Google Sheets....TUTORIAL
How to Connect Google Sheets to PostgreSQL
August 10, 2022 • By Felix Zumstein
This tutorial shows you how to query a PostgreSQL database from Google Sheets with Python and xlwings PRO. PostgreSQL is an open-source database that’s super powerful and one of the most popular choices in the Python world. This tutorial concentrates on querying a PostgreSQL database directly from Google Sheets. This saves you from the manual and error-prone tasks of having to export data from PostgreSQL into CSV files, only to import them again into Google...TUTORIAL
How to Connect Google Sheets to Oracle
August 10, 2022 • By Felix Zumstein
This tutorial shows you how to query an Oracle database from Google Sheets with Python and xlwings PRO. Oracle is one of the most commonly used database products at big enterprises. This tutorial concentrates on querying an Oracle database directly from Google Sheets. This saves you from the manual and error-prone tasks of having to export data from Oracle into CSV files, only to import them again into Google Sheets. You’re also able to give...TUTORIAL
How to Connect Google Sheets to MySQL
August 10, 2022 • By Felix Zumstein
This tutorial shows you how to query a MySQL database from Google Sheets with Python and xlwings PRO. MySQL is one of the most popular open-source databases and currently owned by Oracle. This tutorial concentrates on querying a MySQL database directly from Google Sheets. This saves you from the manual and error-prone tasks of having to export data from MySQL into CSV files, only to import them again into Google Sheets. You’re also able to...TUTORIAL
How to Connect Google Sheets to MariaDB
August 10, 2022 • By Felix Zumstein
This tutorial shows you how to query a MariaDB database from Google Sheets with Python and xlwings PRO. MariaDB is a fork of MySQL and was created by one of the founders of MySQL when MySQL got bought by Oracle. This tutorial concentrates on querying a MariaDB database directly from Google Sheets. This saves you from the manual and error-prone tasks of having to export data from MariaDB into CSV files, only to import them...