SlideCommentSheetSync 📊🔄📑

[email protected] ┃ @zeeshanahmad4 ┃ zee#2655 ┃ Zeeshan Ahmad
For discussion, queries, and freelance work. Do reach me.👆👆👆

Table of Contents 📖

• 🗺️ Project Overview
• ✨ Features
  • To-Do Features
• 📋 Requirements
• 💡 Usage Examples
  • 🚀 Setup and Installation Instructions
• 🔧 Troubleshooting Tips
• 🤝 Contribution Guidelines

Project Overview 🗺️

SlideCommentSheetSync is designed to streamline business processes by automatically transferring @mentioned comments from Google Slides to a designated Google Sheet. This tool is invaluable for teams looking to enhance their workflow and ensure all feedback and notes in presentations are tracked and actionable.

Features ✨

• Automatic Triggering: Activates whenever a new comment containing "@googlesheet" is added to Google Slides.
• Google Sheets Integration: Automatically adds new comments as rows in a specified Google Sheet with links back to the slide.
• Scalability: Designed with scalability in mind to handle multiple comments and slides efficiently.

To-Do Features 📌

• Extended Filtering: Add capabilities to filter comments based on additional keywords or user tags.
• Notification System: Implement notifications when new comments are transferred to the sheet.
• Analytics Integration: Provide options to analyze comment data for trends and common themes.
• User Interface: Develop a user-friendl

Requirements 📋

• Google Apps Script
• Access to Google Slides and Google Sheets APIs

Usage Examples 💡

// Set up the trigger

// Manually add a comment to Google Slides to see the automation in action.

Setup and Installation Instructions 🚀

1. Open the Google Apps Script editor.
2. • Create a new project and name it SlideCommentSheetSync.
3. Copy and paste the provided scripts into the respective files.
4. Replace placeholder IDs with actual Google Slides and Sheets IDs.
5. Run the setupTrigger() function to initialize the triggers.

Troubleshooting Tips 🔧

• Ensure that you have appropriate permissions for both Google Slides and Google Sheets.
• Check the execution log in Google Apps Script for detailed error information.
• Verify that the trigger is set up correctly and has not been disabled.

Contribution Guidelines 🤝

We welcome contributions from the community! Please follow these guidelines:

• Fork the repository.
• Create a new branch for each feature or improvement.
• Send a pull request from each feature branch to the main branch for review.