Sheetcrunch - Google Sheet data converted into REST API

Hey! Have you heard?

Google Spreadsheets has been a staple tool used by countless companies and organizations for various usages. It's easy adaptability, flexibility and the encouragement of collaboration could very well be the reason for its wide adoption.

We'll have you know that you can do so much more with your Google Spreadsheets now, as it can be a database for your business. By using Sheetcrunch, you'll be able to generate your backend RESTful API in minutes, just by uploading your Google Spreadsheet onto the platform. It simply establishes a link between the system and your Google Spreadsheet, thus allowing you to perform data operations onto your data stored on that spreadsheet, returning you with well structured JSON responses!

Using this approach is a great way for a number reasons, and we'll list some of them here.

  • Generate backend API in minutes
  • Focus on how your business work rather than how to get it to work
  • A quick way of prototyping your next big idea
  • Save development cost
  • Speed up project development
  • Everything just works!

Excited yet? We are! Let's take you on a step by step guide on how to get setup right away!

Step 1 - Prepare your Google Spreadsheet

If you don't have an existing Google Spreadsheet, create one! Then, it's time to structure your spreadsheet AKA database. The first row will be treated as the column name for that particular column, and we generally suggest that you have an unique identifier to identify the different rows of data for easier data manipulation in the future.

You can checkout an example spreadsheet to give you a better idea on how to setup your structure.

Sheetcrunch | Sample Google Spreadsheet data

Step 2 - Share it!

Remember to configure your shareable link with the "Editable" permission. To do this, simply adhere to the following steps :-

  • Click on the "Share" button
  • Click "Change" in the "Get Link" section
  • Make sure the "Anyone with the link" option is selected
  • Make sure the "Editor" option is selected
  • Click "Done"

And you're done with the setup of your spreadsheet. You need keep a copy of your spreadsheet URL as you'll need it later during API creation.

Sheetcrunch | Share your Editable Google Spreadsheet

Sheetcrunch | Your Google Spreadsheet URL

Step 3 - Create a Sheetcrunch Account!

Once you've setup your spreadsheet, it's time to create a Sheetcrunch account. Head on over to the sign up page to get started. Alternatively, you could just login if you already have an account.

And you're in! You'll be presented with your spreadsheets page, but it's empty now, so start uploading your first spreadsheet!

Sheetcrunch | Your Home Page

Step 4 - Create Your First API

You'll be presented with the home page where it prompts you to upload your first spreadsheet. Input a name for your API, and upload your spreadsheet URL from earlier.

When your spreadsheet has been uploaded successfully, you'll see your first spreadsheet in the table!

Sheetcrunch | Your First Spreadsheet

That's it!

Now you can start exploring the various features and what you can do with your data.

Head on over to the documentation to get a more information on how to use your new API.

Sheetcrunch | Your First Spreadsheet Control Panel

Hopefully, we've helped you understand more, and that you've got your Sheetcrunch API running! If you have any questions, feel free to contact us at [email protected].