First add-on published

My first Google sheets add-on is published! To be totally honest, I made it mainly to see what was involved. I really like the work that Andrew Stillman has been doing with New Visions for Public Schools, including Doctopus and formMule, and I wanted to see if I could do similar things for higher ed or international ed.

My add-on is called Text Adder, and it pretty much just does what the name indicates. Once it’s installed, the user can select a range of cells, and Text Adder will add a chosen text to the beginning or end of every cell in the range.

Text Adder

Text Adder in the add-on store

Why did I choose this for my first foray into the add-on store? I got the idea by answering this question on Quora. The question (“I need to add a word before every already existing word in a Google Sheet or Doc. How can I do it?”) seemed pretty silly, but a friend told me that it was a real issue the comes up, so I decided to give it a crack. After I’d answered it with Google Apps Script, it was just a matter of adding some HTML and CSS to turn it into an add-on.

My next add-ons will probably focus on languages or finance, since those are two spreadsheet topics that I’m interested in. I’d love to hear feedback on Text Adder or suggestions for other projects.

Advertisements

About Finn Smith

Oregon... some places.... SF. Working in education, technology, and social impact (or some combination of the three).
This entry was posted in Google Apps Script. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s