How to edit the QuickSpell spreadsheet
So that the bot can easily write your data into it
What can you do with a spreadsheet?
  • Add entries via bot or by hand
    If you add new records manually, enter the date in the Date column in the DD.MM.YYYY format, and the amount in the Amount column as a number without a currency symbol and without spaces between digits. You can enter anything in the comment field, but it's best to avoid line breaks.
  • Edit and delete entries
    When editing, make sure that the date in the Date column is specified in the DD.MM.YYYY format, and the amount in the Amount column is a number without a currency symbol.
  • Create new sheets in a spreadsheet
    If you need additional analytics, charts, reports, or summaries, you can create a new sheet in the spreadsheet and add your own formulas to it.
  • Combine records into groups
    If you want to group your entries by month for easier work, you can do so using the grouping feature in Google Sheets.
What not to do
  • Change the names of original sheets
    This may cause problems with adding new records and analytics. You can change the names of sheets you've added yourself.
  • Remove columns, add columns, change column headings in the original sheets
    This may prevent the bot from writing entries to the sheet.
  • Add records to the last row of the Records sheet
    This may prevent the bot from writing entries to the sheet.
Rules for adding new rows to the Records sheet
If you add new lines by hand or edit existing ones
  • Dates in the Date column must be in the format DD.MM.YYYY
    You can also leave this cell blank.
  • The amounts in the "Amount" column must be indicated as numbers without spaces or currency symbols.
    You can also leave this cell blank.
  • In the "Author" and "Comment" columns you can enter text in any format
    It's best to avoid line breaks in the text. You can also leave these cells blank.
  • In the "Tag" column, you should put the # symbol before the category name and use underscores instead of spaces. Like this: #utilities_payments.
    You can also leave this cell empty or add the #no_category tag to it.
Made on
Tilda