OPENS A WORLD OF OPPORTUNITIES FOR YOUR APPS
Store Data in Google Sheets using Xamarin iOS & Android apps
Swiftly create a simple backend for your Feedback page
There have been questions on StackOverflow asking how to use Google Sheets to store data using Xamarin, as a quick and simple database. After finding no articles online, I decided to spend a few hours to figure it out. Using the steps below, you can use a Restful POST API call to send data from Xamarin iOS & Android apps, to instantly populate rows in a Google Sheet.
Introduction
We are going to demonstrate adding rows to a Google Sheet using a Feedback form to collect user feedback. Why did I choose this specific use case? If you are an Indie mobile developer, you probably know that collecting feedback can be important, so if you know a user is not satisfied with the app, you can redirect the user to this Feedback page instead of the Play/App Store. Note that this procedure doesn’t implement any authentication, so it cannot replace a backend, and I would also not recommend using this in production apps that require security.
What do you need to follow this? You just need Visual Studio with Xamarin installed on your Windows or Mac computer, and a Google Drive account…