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
- A staff member sends a questionnaire to the bot.
- The bot parses the file and writes mapped data.
- The staff member gets a link to the result.
- 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.