title: Sync data between Google Firestore and Google Sheets using Cloud Functions/Admin SDK
body: <p>While using Cloud Firestore as data backend, I need to share some data collections with non-tech site managers (editors, sales teams, etc.). Also, I wish to give these people access to edit the data stored in Cloud Firestore.</p>
  
  <p>Google Sheets is a very familiar tool with site managers which can save me time in developing a CRUD admin panel like the interface from scratch for data updating and viewing. </p>
  
  <p>This Stack Overflow <a href="https://stackoverflow.com/questions/46640981/how-to-import-csv-or-json-to-firebase-cloud-firestore/47491711#47491711">answer</a> shows how to send data using cloud function and levels deep, and this Github <a href="https://github.com/grahamearley/FirestoreGoogleAppsScript" rel="nofollow noreferrer">library</a> can get data from Firestore using Google Apps Script (I wish to do it using Cloud Functions or Firebase Admin SDK), but I am still trying to figure out how to make an end-to-end Sheets based interface.</p>
  
  <p>Please guide if there are any better alternatives to achieve the same objective. I'm facing some difficulties switching from SQL databases and Django auto-created admin interfaces to the Firebase-Firestore NoSQL world. </p>