I want to create a simple form like interface which will help me perform mail merge using Google Docs as template file and Notion Database as the source of database.Here's how it will work in 4 steps flow:Intro Form - When the user is logged in, I want to show the message:"Welcome {{UserName}} to PDFOutput!To automate pdf generation, we need the following:a. Google Document - Create a Google Doc template file with placeholders in the form of {{placeholder_text}} such as {{ClientName}}, {{InvoiceNumber}} etc.b. Notion Database - Create a Notion Database with matching placeholders in the database containing rows of data in it.To begin, let's first start with selection of Google Doc, click on "Get Started" to proceed...When the user clicks on "Get Started" button, then Step - 1 Add Google DocumentIt will show field Select Google Doc and a button below that "Add Google Doc"Once user clicks on "Add Google Doc" a google picker will open and the user can select a file from the picker.Once the file is selected, it will automatically read the file and find the placeholders in the file and show either of the following message:X placeholders found in the google doc file selected, click "Next" to proceed.orNo placeholders in the form of {{placeholder_text}} found in the document, please add placeholders in the document such as {{clientname}} or {{invoicenumber}} to proceed with the automation...Step - 2 Add Notion DatabaseSelect Notion Database"Add Notion Database" buttonUser can click on the button and add notion database and show a dropdown below that showing all the notion databases in it.Once a database is selected, show the message "X fields fetched from the Notion Database".Click "Next" to proceed.Step - 3 Mapping PropertiesThis will show "Google Document" placeholder properties on the left and corresponding to each property it will show a dropdown containing the "Notion Database" properties in a dropdown list.Make sure to automap the fields if anything matches otherwise let the user manually map the propertiesOnce the user clicks on "Generate PDFs" then it will generate the pdfs one by one as neededCreate me this entire form sequence frontend part
Loading...
It looks good can you make it more professional and make sure its mobile friendly and visible across all devices
Loading...
I want to use drive.file scope for this and use the batch.export feature of the google drive api scopes to export the pdfs and also use notion public oauth to add the databaseAlso I want to use the google picker api to select the google docs file