There is a way to Sync a Google Sheet with a SQL or NoSQL Database?

Sebastien-Gath Published at Dev

22

Sebastien-Gath

As im not a developper i often use Google Spreadsheets to prototype my projects.

Now I would like to connect a sheet to a database (like Mongo). As my data can changes daily (i also use Zapier for automated actions) i assume it would be more easy to Sync my sheet with the database i use.

After a search on the Internet, i didnt find a solution. Do you have any clue ?

Thanks, Seb.

Kresimir Pendic

You can use free 1GB of firebase (cloud noSQL DB) for free, and if that's good enough for you then you can sync data from G Sheets->Firebase via custom Library,, more details here:

https://sites.google.com/site/scriptsexamples/new-connectors-to-google-services/firebase

my video could help you maybe: https://youtu.be/9SIAnjgKZZQ

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2020-10-26

Comments

0 comments

Login to comment

Related

Provide sync between PostgreSQL and NoSQL database

Is there a way to force Sitecore to sync MongoDB data with it's SQL database?

Best Way for Search GPS points in a NOSQL Database

How to sync the data google sheet data dynamically?

Fitbit sync with Google Sheet, running into error, Exception

Nosql or sql database for big temp data

Database Design - SQL or NoSQL - CSV data

How to use google Sheet as an database

Is there any way to convert SQL Server date time into format that be read by Google Sheet?

What is faster way to connect to SQL database on Google Cloud

Backup and sync SQLite database with Google Drive logic?

How to sync Firebase Database with Google Sheets?

Write Database data into Google sheet. Java, Googe Sheet API

Is there a way to get the last sheet name in Google-sheet scripts?

Programmatic Way to Transfer Google Sheet CSV to Dropbox

Better way to get access to Google Sheet with Python

Is there a way to fetch the URL of the current google sheet?

A way to access a google sheet from drive in Unity

Best Database for Blog Application (Relational - SQL vs NoSQL)

saving Firebase Realtime Database data into SQL table or NoSQL table

SQL/NoSQL Database Management System with asynchronous C++ driver

Is WHERE EXIST supported in the Oracle NoSQL Database SQL query?

We use nosql for mongodb in the same way we use sql for oracle?

Sync sqlite database from sql server

Sync two database tables SQL Server

NoSql Offline sync with remote server

Google Sheet SQL WHERE CLAUSE Syntax

How to generate SQL code from Google Sheet

Is there any way to package google script code as add-on to google sheet?

TOP Ranking

Article

HotTag

Archive