[USEFUL] Simple classifieds engine with google sheet database backend [CODE]

in utopian-io •  2 months ago

If you want to post a classified (ads, some lots to sell, etc.) on your website fast and easy, or if you're having to post a lot of them, google sheets can help. Just add this code to your server and you're ready to go.

Technology stack and dependencies of the project

  • [Physical] Ubuntu Server with LAMP
  • This repository
  • Handlebars.js (included in /js)
  • TableTop.js (included in /js)
  • jQuery (included in /js)
  • Google Sheets table with db structure like below

Database structure


The rows are lots (sale items).

Required fields: name, price, email

Automatically given: timestamp

Optional fields:

  • desc - description
  • date_from - date to start publishing an add/classified (for scheduling purposes)
  • date_to - date to hide the add/classified
  • condition - lot condition (working / broken / unknown)
  • picture_url - link to lot image
  • yandex_money - yandex.money wallet
  • btc - BTC wallet
  • ltc - LTC wallet
  • eth - ETH wallet

Example screenshot


Project presentation (in Russian)


git clone https://github.com/sxiii/oldhack

Example project

ToDo / Help needed & RoadMap

  • Implement registration and ads editing
  • Implement a working Cryptocompare API to calculate price for ads
  • Clean javascript libraries, maybe rewrite everything

Tested web browsers



GitHub Account

Hope this project will be useful for you. Please feel free to ask, test, comment, and contribute.

Cheers :),
Den Ivanov aka @sxiii from Random City

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

Thank you for your contribution. In the current state, it seems like a small project where you are just displaying the data from the excel to a website, but RoadMap looks great. One thing is that you can move the hard-coded excel file location to some configuration file.

Your contribution has been evaluated according to Utopian policies and guidelines, as well as a predefined set of questions pertaining to the category.

To view those questions and the relevant answers related to your post, click here.

Need help? Write a ticket on https://support.utopian.io/.
Chat with us on Discord.


Thank you for your review, @codingdefined! Keep up the good work!

Hi @sxiii!

Your post was upvoted by @steem-ua, new Steem dApp, using UserAuthority for algorithmic post curation!
Your post is eligible for our upvote, thanks to our collaboration with @utopian-io!
Feel free to join our @steem-ua Discord server

Hey, @sxiii!

Thanks for contributing on Utopian.
We’re already looking forward to your next contribution!

Get higher incentives and support Utopian.io!
Simply set @utopian.pay as a 5% (or higher) payout beneficiary on your contribution post (via SteemPlus or Steeditor).

Want to chat? Join us on Discord https://discord.gg/h52nFrV.

Vote for Utopian Witness!