Hi Supabase team,
It would be extremely useful to have a native Google Sheets integration in Supabase. This would benefit both free and paid users by enabling easier data backups, reporting, and manual data management through a familiar spreadsheet interface.
Many developers use Google Sheets as a simple backup for their database. A built-in integration could allow automatic syncing between Supabase tables and Google Sheets.
Suggested features:
Example use cases:
• Two-way sync between Supabase tables and Google Sheets • Option to export a table to a Google Sheet automatically • Real-time or scheduled sync (for example every 5 minutes) • Ability to select specific tables or columns for syncing • Automatic sheet creation based on the Supabase table schema
This feature would make Supabase even more powerful for developers and non technical user.
Thanks for the amazing work on Supabase!
Samir Mulla suggests a native Google Sheets integration with Supabase to enable two-way sync for easier data management and backups. The proposed features include real-time or scheduled sync, automatic sheet creation, and selective table syncing. Aniruddha Adak responds by highlighting the complexity of conflict resolution in two-way sync and suggests using Edge Functions or middleware like Retool or Zapier for more robust solutions.
@Samir-Mulla Native 2-way sync with Sheets is tough because of conflict resolution (Sheet rows vs SQL constraints). However, using Edge Functions triggered by Database Webhooks is a great way to push to Sheets (One-way). For Two-Way, tools like Retool or Zapier middleware are usually more robust than a direct native integration, as they handle the polling/diffing logic.