Demo

1. Getting prepared

Start by downloading Postman for free, this will be used for testing.

2. Creating a test Google Sheet

Now let's setup a sheet with some dummy data.

3. Setting up the request

Let's grab our ID and and API Key from the MilkySheet Dashboard. We can then add this into our Header section in Postman.

Now let's build the URL with our test Google Sheet: https://api.milkysheet.com/1l4CVdF1ifZ6Zm8tt4jNkpHqRsk3MoTTxsllf6uD906M/TestSheet

4. Getting the Data

Let's make a GET request to load the test sheet into Postman.

5. Posting a new row

Let's add a new row in with the POST command.

MilkySheet will respond to let us know the row has been added successfully.

We can confirm row has been added to the sheet.

5. Editing a row

Now let's make a quick change to one of the rows in our data with the PUT command.

Again, MilkySheet will confirm row has been updated:

Let's check Google Sheets.

6. Deleting a row

Lastly, we can delete a row with the DELETE command. Let's delete our newly created row.

MilkySheet confirms the row has been deleted.

And the row was deleted successfully!