From Word/Excel to JSON: complete automation of the questionnaire creation process

The Customer Success team had to create customized questionnaires for each customer, based on Word or Excel documents they sent us.

Each question had to be copied and pasted manually into the application editor, a repetitive and time-consuming task that could take up to an hour per questionnaire.

• I developed an internal tool that automates this process:

• Automatic extraction of content from Word and Excel files using Mammoth and SheetJS.

• Transform content into JSON using custom prompts that are fully compatible with our editor.

• Direct integration into the back office for quick and easy use by the team.

• section_works_3_4_solution

• section_works_3_5_solution

• A gain of 3 hours per week for the Customer Success team, which can now focus on providing strategic support to customers rather than copying and pasting.
• section_works_3_1_impact
• section_works_3_2_impact