Toni Jansen ToniJansen
ToniJansen
/ youtube.py
Created
April 17, 2025 01:38
— forked from philschmid/youtube.py
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import os | |
| from google import genai | |
| from google.genai import types | |
| client = genai.Client(api_key=os.getenv("GEMINI_API_KEY","xxx")) | |
| # Repalce with the youtube url you want to analyze | |
| youtube_url = "https://www.youtube.com/watch?v=RDOMKIw1aF4" | |
| # Prompt to analyze and summarize the Youtube Video |
ToniJansen
/ export-named-sheet-as-csv.gs
Created
June 22, 2023 02:37
— forked from mrkrndvs/export-named-sheet-as-csv.gs
Google apps script to export an individual sheet as csv file
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| * script to export data of the named sheet as an individual csv files | |
| * sheet downloaded to Google Drive and then downloaded as a CSV file | |
| * file named according to the name of the sheet | |
| * original author: Michael Derazon (https://gist.github.com/mderazon/9655893) | |
| */ | |
| function onOpen() { | |
| var ss = SpreadsheetApp.getActiveSpreadsheet(); | |
| var csvMenuEntries = [{name: "Download Primary Time File", functionName: "saveAsCSV"}]; |
ToniJansen
/ gist:294478690a99a1f68b43c63814bbb2eb
Created
July 28, 2018 01:38
Simple Google Apps Script to export a single sheet to PDF and email it to a contact list
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Simple function to send Weekly Status Sheets to contacts listed on the "Contacts" sheet in the MPD. | |
| // Load a menu item called "Project Admin" with a submenu item called "Send Status" | |
| // Running this, sends the currently open sheet, as a PDF attachment | |
| function onOpen() { | |
| var submenu = [{name:"Send Status", functionName:"exportSomeSheets"}]; | |
| SpreadsheetApp.getActiveSpreadsheet().addMenu('Project Admin', submenu); | |
| } | |
| function exportSomeSheets() { |
ToniJansen
/ Pull-and-Sync-Data-Between-Google-Doc-Spreadsheet-and-MySQL.gs
Created
December 16, 2017 01:01
You can pull data from MySQL database to Google doc spreadsheet auto with just click of a button or scheduled time. This is great use for retrieving data in spreadsheet format.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // MySQL to Google Spreadsheet By Pradeep Bheron | |
| // Support and contact at pradeepbheron.com | |
| function myMySQLFetchData() { | |
| var conn = Jdbc.getConnection('jdbc:mysql://127.0.0.1:3306/employee_db', 'username', 'pass'); // Change it as per your database credentials | |
| var stmt = conn.createStatement(); | |
| var start = new Date(); // Get script starting time | |