Automation Scripts

This repository contains scripts created to automate various tasks during my social service internship.

Files

• renameFilesGUI.py: A GUI application for renaming PDF files based on the text extracted from the first page using OCR. It uses tkinter for the GUI, pdf2image for converting PDFs to images, and pytesseract for OCR.

• renameFiles.py: A script for renaming PDF files based on the text extracted from the first page using OCR. It uses pdf2image for converting PDFs to images, and pytesseract for OCR.

• remove_dates.js: A script for updating a Google Form's dropdown options based on the availability of dates in a Google Sheet. It uses Google Apps Script to interact with Google Forms and Sheets.

Usage

renameFilesGUI.py

1. Run the script: python renameFilesGUI.py
2. Select the input folder containing the PDFs to be renamed.
3. Select the output folder where the renamed PDFs will be saved.
4. Click "Ejecutar" to start the renaming process.

renameFiles.py

1. Update the paths for pdf_folder, output_folder, poppler_path, and tesseract_cmd in the script.
2. Run the script: python renameFiles.py

remove_dates.js

1. Open the script in the Google Apps Script editor.
2. Update the formId and sheetId with the correct IDs.
3. Run the updateFormOptions function to update the form options based on the availability of dates in the Google Sheet.

Dependencies

• Python 3.x
• pdf2image library
• pytesseract library
• tkinter library (for renameFilesGUI.py)
• Google Apps Script (for remove_dates.js)