Assistant Apps Script 💻 by TOUTAIN Anthony
Last updated on June 05, 2024 Engagement: Over 300 ConversationsGPTs agissant comme un assistant expert en Google Apps Script pour l'automatisation de vos tâches sur Google Workspace (Google Sheet, Slide, Gmail, Doc, Form, Drive)
- Author
-
TOUTAIN Anthony View Author GPTs
- Author website
- Share this GPT
- GPT Message
-
Prompt Starters
-
-
Comment fonctionne Apps Script ?
-
Traduction Google Slide : Aide-moi à créer un script pour traduire automatiquement mes slides Google (texte, forme, tableau) du français à l'anglais..
-
Publipostage Gmail : Aide-moi à créer un script pour réaliser un publipostage via Gmail à partir d'un Google Sheet contenant en colonne A "L'adresse email du destinataire", en colonne B "L'objet de l'email", en colonne C "Le contenu de l'email", en colonne D "Le lien vers la pièce jointe hébergé sur Google Drive". Les mails doivent être enregistrés dans mes brouillons afin que je puisse les valider avant de les envoyer.
-
Doublon Google Sheet : Créer moi un script pour identifier en rouge les cellules en doublon dans la colonne sélectionnée dans Googgle Sheet. Ajoute en commentaire de cellule, le nombre et la localisation des doublons. Ajoute en fin d'exécution du script un message dans une pop-up indiquant le nombre de doublons identifiés.
-
Mise en forme Google Sheet : Peux-tu ajouter un bouton sur Google Sheet qui puisse mettre automatiquement en forme ma feuille Google Sheet en : 1 ajustant la longueur et la hauteur des cellules au contenu des cellules, 2 centrant le contenu des cellules en hauteur et en largeur. Mettant en gras la première ligne de mon tableau. Si une colonne se nome "NOM" mettre le contenu des cellules en majuscules, si une colonne se nome "Prénom" mettre le contenu des cellules en nom propre (Cad une majuscule au premier caractère puis des minuscules pour chaque mot). Si une colonne contient la mention "en €" mettre le format des cellules en euro.
-
-
Features and Functions
-
-
DALL·E: This tool generates images from textual descriptions, providing a creative way to visualize concepts, ideas, or detailed scenes. It can produce images in various styles and formats, based on specific prompts provided by the user.
-
Python: The GPT can write and run Python code in a stateful Jupyter notebook environment. It supports file uploads, performs advanced data analysis, handles image conversions, and can execute Python scripts with a timeout for long-running operations.
-
Browser: This tool enables ChatGPT to perform web searches, access and summarize information from web pages in real-time, and provide up-to-date answers to questions about current events, weather, sports scores, and more.
-
Knowledge file: This GPT includes data from 1 files.
-
Rate: 4.1 ★
The ultimate document assistant. Securely store and chat with PDFs, CSVs, TXT, Markdown and Excel with a free AI Drive account. Offers OpenAI, Claude and Google AI models + OCR and folder search. Boost productivity with our Chrome extension. Transform your workflow today!
Rate: 4.1 ★
Free Chat Unlimited PDFs, Access 400M+ Papers (PubMed, Nature, Arxiv, etc), Analyse PDF (Unlimited PDFs), Generate articles/essays with valid citations, ChatPDF, Analyse and generate references for papers, create and interact with a knowledge base of your files and much more using AskYourPDF.
Rate: 4.2 ★
Text to Video Prompt Maker is a tool that generates detailed video creation prompts from user-provided text descriptions, enabling content creators to efficiently design and produce engaging visual content.
Rate: 3.9 ★
Turn your ideas into videos with text-to-speech and AI visuals.
Rate: 4.3 ★
A gpt expert at solving programming problems. We have open-sourced the prompt here: https://github.com/ai-boost/awesome-gpts-prompts (This GPT isn't perfect, let's improve it together! 😊🛠️)
Rate: 4 ★
I predict future stock market prices. AI analyst. Your trading analysis assistant. Press H to bring up prompt hot key menu. Not financial advice.
Rate: 4.2 ★
Professional academic assistant with a professorial touch
Rate: 4.2 ★
The worlds most powerful coding assistant.
Rate: 4.3 ★
Create a 100% SEO Optimized Article in any language | Title | Meta Description | Headings | FAQs
Rate: 3.9 ★
Your travel planning assistant for flights, hotels, & cars
Rate: 4.4 ★
Quick YouTube, US equity data, and web page summarization with vector transcript search -- no logins needed.
Rate: 4.3 ★
Professional academic assistant with a professorial touch
Rate: 4.1 ★
👨💻 Reviews code, generates and optimizes functions, writes tests, and adds comments for existing code. 👩💻
Rate: 3.8 ★
Extracts and summarizes YouTube video transcripts in any chosen language, removing language barriers. Converts the summaries into embeddable HTML articles for websites.
Rate: 4.4 ★
A writing assistant specializing in book creation, web research, and format recommendations.
Rate: 4.7 ★
Create Music With AI, transform your lyrics or description to AI song with our AI beat maker, more powerful than udio and suno.
Rate: 3 ★
Transform a description into lyrics, which can then be used with the AI Music Generator to create a song.
Rate: 4.2 ★
🟡 Now with hotkeys and the latest docs about +10,000 libraries, APIs, and SDKs. Python assistant and code generator, with a focus on efficient, scalable, and high-quality production code. Prefers to use open-source libraries rather than writing code from scratch.
Rate: 4.5 ★
Automatically create home and & gym workouts (Also available as app on the AppStore)
