Database Integration Guide

Google Sheets Setup Guide

Learn how to connect your own custom Google Sheet database to the Aarti Sangraha Android app to add, sequence, and manage your devotional Aartis, Mantras, Stotrams, and Chalisas dynamically!

Copy Pre-Made Template Sheet Build Sheet From Scratch
1

Method A: Copy Official Template

The fastest way to get started! Use our pre-structured Google Sheet template pre-filled with popular Aartis (Ganesh Aarti, Hanuman Chalisa, Shiv Aarti, Lakshmi Aarti, Om Jai Jagdish Hare).

Open Copy Template Link
2

Method B: Create Custom Sheet

Create a blank Google Sheet in your own Google Drive and set up the 8 required column headers manually to build your personalized prayer collection.

View Column Schema

Step-by-Step Instructions

Step 1: Copy or Create the Google Sheet

Click the Template Copy Link . When prompted in Google Drive, click "Make a copy". This saves a copy of the spreadsheet directly into your personal Google Drive account.

Step 2: Add or Edit Your Prayers & Aartis

Add new rows or edit existing devotional texts in Hindi, Marathi, Sanskrit, or English Devanagari script. Make sure to keep the exact column header titles intact in Row 1.

Step 3: Publish the Google Sheet to the Web (CSV)

To allow the Aarti Sangraha app to fetch data seamlessly without requiring user logins:

  1. In Google Sheets, click File in the top menu bar.
  2. Select Share > Publish to web.
  3. In the Publish modal, select Sheet1 (or Entire Document) and change the format dropdown from Web page to Comma-separated values (.csv).
  4. Click Publish and confirm.
  5. Copy the generated published web link (it will end with output=csv).
Note: Publishing to web makes the spreadsheet readable as a public CSV file endpoint. Do not put sensitive personal passwords or private data in this sheet.

Step 4: Sync inside the Aarti Sangraha App

Open the Aarti Sangraha app on your Android phone:

  1. Tap the Settings / Database Sync icon in the app toolbar.
  2. Paste your copied Google Sheet published CSV URL into the Database URL field.
  3. Tap "Sync Database Now".
  4. The app will automatically parse the rows, order them by sequence number, and save them to your local offline Pothi library!

Google Sheet Column Structure Reference

If creating a sheet from scratch, the first row (Row 1) must contain these exact column names (case-insensitive):

Column Name Type Description & Example Required?
Sequence Integer Order of display in app (e.g. 1, 2, 3) Required
Title Text Title of the Aarti/Stotra (e.g. जय गणेश जय गणेश देवा) Required
Deity Text Associated deity (e.g. Ganesh, Shiv, Hanuman, Lakshmi) Required
Category Text Category classification (e.g. Aarti, Chalisa, Stotra, Mantra) Required
Language Text Script language (e.g. Hindi, Marathi, Sanskrit, English) Optional
Content Text (Multi-line) Full devotional lyrics/scripture verses with line breaks Required
AudioUrl URL Direct MP3 audio stream link (e.g. https://example.com/audio/ganesh.mp3) Optional
Tags Text Comma-separated tags (e.g. Morning, Friday, Festival) Optional

Frequently Asked Questions

Yes! Aarti Sangraha uses an offline-first Room database architecture. When you sync your Google Sheet, all texts are saved locally on your phone. You can read your Aartis in Pothi mode without any mobile internet or Wi-Fi connection.

Whenever you add or modify rows in your Google Sheet, simply tap the Sync button inside the app. The app will fetch the latest CSV revision and update your local library automatically.

Ensure that:
  • You published the sheet using File > Share > Publish to web as a CSV file.
  • The URL contains output=csv or /pub?output=csv.
  • Row 1 contains the exact column names: Sequence, Title, Deity, Category, Content.