Show IH: The all-in-one tool to manipulate data in your spreadsheet

Hi indie hackers,

I just launched my first web app: A Google G Suite add-on that helps you manipulate your data in Google Sheets. It called Logic Sheet and is now available on Google Workspace Marketplace. The app is totally free for now, but I'm planning to add more functions to it and start charging users.

What does it do?

I designed Logic Sheet to be an all-in-one tool for data processing tasks in Google Sheet. But currently, I only added around 12 functions to the add-on. They include an API connector, which helps you retrieve data from an API endpoint through the GET or POST methods. You can also use the function to send data in your spreadsheet to an API endpoint and get the processed data.

I also integrated Alpha Vantage, a finance data database with the add-on so that users can seamlessly retrieve share prices, company earnings data, and forex exchange rates directly from their Google Sheets.

Other functions include inserting a growth rate column to a column of data, inserting a running total column, unpivot data, and remove duplicates.

The backstory

I started Logic Sheet after an attempt to make a niche search engine of well-written English sentences. I am a non-native English speaker who works for an English tech news outlet. One of the biggest challenges for me in the job is how to find the right word and write better English sentences like a native English speaker.

The idea of the project was to crawl articles published on prestigious English news outlets like Reuters, The New York Times, and The Economist and segment those articles into sentences and store than in an ElasticSearch database so that I can do quick searches of those sentences. (The content was provided to users only in sentence snippets, so there are no copyright issues. Just like Google, which only shows snippets of an article and gives you a link to the original article.)

But to do this, I need to do sentence segmentation (or sentence tokenization) of the articles I crawled. I found IMB provides a natural language processing API that can do such a task. So I started using Google Sheets to call the IBM API to segment articles I store using Google Apps Script.

It worked well, but more importantly, I found Google Apps Script is such a powerful tool and I think I may be able to open the call API function to other users. That's how I came to pivot my little side project to a Google Sheets add-on. (The sentence search engine is still under development. I'm still enriching the database)

How to get it?

Logic Sheet is now available on Google Workspace Marketplace. If you want to try it out, click here:
https://workspace.google.com/marketplace/app/logic_sheet/796322869198

After installing it, you will be able to find it under Google Sheet's Add-on menu.

I'm currently looking for beta users to test the app and get to know what functions users want the best. If you are interested, you can join my beta group on Telegram. I will provide beta users with one year of free access to the app.

Click here to join the group: https://t.me/joinchat/IagFqGYxrJ58VNCi

Thanks, I look forward to any feedback!