Automation

Excel questionnaires to Google Sheets via Telegram

Staff send an Excel questionnaire to a bot; it maps fields and writes them to a shared Google Sheet.

The task

Simplify collecting questionnaires from templates in different languages and transferring their data to target sheets.

What I built

  • Support Russian and English Excel templates.
  • Map fields to the shared table, including multi-level headers.
  • Return upload status, row number and a link to the sheet.
  • Transfer data to selected tabs of another spreadsheet via Apps Script.

How it works

  1. A staff member sends a questionnaire to the bot.
  2. The bot parses the file and writes mapped data.
  3. The staff member gets a link to the result.
  4. They select tabs in the shared sheet for further transfer.

Outcome

Mapped fields move automatically, and the bot reports the upload result. Multiple templates are brought into one structure.

← All projects