RAW File <Newsletter>

STEP 1: File Arrives
DISCORD:
A notification with <@username> will alert the designer upon file arrival in “#newsletter-daily” channel.GOOGLE DRIVE
- Make a Copy of <.pptx> file from Shared Folder into “My Drive”
- Rename this <.pptx> file in this format: DD-MM-YY.pptx (Ex: 01-01-24.pptx)
STEP 2: File Conversion
GOOGLE CODE COLABORATORY
https://colab.research.google.com/drive/1gRdKN3KrNed5e-l6FpcKXelZgF0l5-r2?usp=sharing








STEP 3: File Processing
GOOGLE DRIVE
- Select and Cut {Ctrl+X} all 3 Items (Img Folder + Newsletter + PPTX)
- Paste into this Location: My Drive / MAGDB / Month / Daily-Newsletter
GOOGLE DOCS
Open the Newsletter Docs file for formatting as Instructed below in video:WATCH VIDEO GUIDE
https://drive.google.com/file/d/1DNvcSWZRNotqgOJKXSebYijQt-EhEKbc/view?usp=drive_link
MCQ Table /w AI
METHOD 1:
Using the URL to Google Colaboratory, In Process 1 of [NEWSLETTER-DAILY], Go to “GENERATE QA /W AI” and enter the full name of Newsletter Document ex: ‘NEWSLETTER-DD-MM-YY-RAW.docx’, the API will process the document and 4 responses will be presented, then Manually Read all 4 Responses one by one and choose only the best table with a good level of Questions-Answers.https://colab.research.google.com/drive/1S6_rGzKJbys0IzNyLCLsiEGPZaCU6k3_?authuser=3#scrollTo=oYGsgKV_uy2f
https://drive.google.com/file/d/1iuOcjKT2beOgjvf-KKSteBbj4bE7oz4g/view?usp=sharing
METHOD 2:
After the Docs file is edited as instructed above, we’ll save the file as Markdown (.md)
https://www.perplexity.ai/search/what-to-do-read-the-attached-c-kuarMG1ORyiwoDjMuE4esQ
NOTION
Update the STATUS to: “In-Progress” Paste the Link to docs file in INPUT-RAW-URLSTEP 4: File Designing
Watch this video to understand the complete design process:https://drive.google.com/file/d/1DNvcSWZRNotqgOJKXSebYijQt-EhEKbc/view?usp=drive_link
CANVA
- Open the associated Design File of Newsletter.
- Use the Newsletter Docs File to update the Design file to Latest Content.
- Insert Images into Design File using the Drive Folder containing the extracted Images.
- Insert Hyperlinks of the associated Newsletter LIVE Sessions.
YOUTUBE
- Open the Channel (https://www.youtube.com/@StudyYRKapilKathpal/streams) and Find associated LIVE Stream URL.
- If URL is not found, the default link to channel must be preserved.
STEP 5: File Cross-Checking
- Check Consistency of Newsletter Content in the final design using the Raw Newsletter Docs File in Split Screen Mode.
- Check for any possible repetition of any content or any unwanted errors.
- Open the Attached URLs of Live Stream to check their workability.
- Check the MCQs: The Qs table and Answer table should be correctly updated to today’s version of the Newsletter.