omou-org / mainframe

Central backend repo.
0 stars 1 forks source link

Integrate with a sheets application #52

Open dhuangg opened 4 years ago

dhuangg commented 4 years ago

Background

Client wants to be able to see their data in a pivot table. We would include this on the admin dashboard.

Possible Solutions

Zapier Integration Automation This is for postgres and google sheets or airtable. You can easily integrate the two with drag and drop components to program: when a new entry on a google sheet/airtable gets added, add an entry to postgres.

Google Sheets to postgres This is a quora answer with potential solutions.

dhuangg commented 4 years ago

Read only access of all the tables in postgres