8
11 Comments

Turn any Spreadsheet into an API

After a couple of months of working evenings and weekends, the MVP for sheet2api is online!

I built this as I needed a dynamic backend for mock-up websites I regularly create. sheet2api essentially gives you a fully functional JSON REST API directly linked up to a Google Sheet or Excel Online spreadsheet.

https://sheet2api.com/

I'd love to hear any feedback or ideas you may have!

on April 28, 2020
  1. 2

    Hey Richard, this is really cool :) Thank you for sharing. Going to use this to write some tutorials. Love the design of the landing page.

  2. 1

    I like it! There so many usecases that came to my mind, like prototyping or database replacement.
    How did you find out which features needed to be in the MVP? Is it based on your own requirements or did you do some research/ interviews etc to prioritize the featureset?

    1. 1

      Luckily, I actually need this product (for the prototyping mainly) so I didn't need to interview anyone. I just showed it pre-launch to a couple of developer friends to get early feedback and correct some bugs.

      1. 1

        But you also want to sell you're product, so you might have different requirements for the MVP. E.g. if you would have built this just for your personal use for your own projects, you wouldn't need such a good looking UI.
        I'm stressing this because I also work on a product that I came up with for personal use - but would also love to sell to others on a subscription base. And now I need to define the features that are relevant for the MVP. I'm struggling with this task because I have a mix of things that are important to me and things that I assume that are important to others. And I have some (only a few) feedback and I'm not sure how to prioritize the different perspectives (mine, what others say, what I think that others would love).
        How do you deal with this?

        1. 1

          try glidr.io to help organize your ideas and research. build something your passionate about but don't build it as a product because you like it, focus your MVP on solving problems for an accessible target audience.

        2. 1

          I'm farrr from an expert at this but I would:

          1. Find out where those people hang out online (communities) and see what they're talking about.

          2. Use keyword research tools (like https://ahrefs.com/) to see that people are searching for.

          From those, I'd assume you'd get a good idea. Maybe your question warrants a separate post though so more people can chime in with other ideas.

  3. 1

    This is brilliant! Well done @richardindie!

    Not knowing much about APIs, I'm trying to figure out ways I could use this...

    1. 1

      If you dream up an idea let me know. I'm happy to make a little tutorial about it.

  4. 1

    This is cool. I'm working on a project that uses sheets to grab data to send to a dashboard. With my limited skills, I might be able to get something to work using this!

    1. 2

      If you get stuck at all send me an email. Happy to help!

  5. 1

    This comment was deleted 6 years ago