adminProject Scope:
A – Managing Comments on Our Own Videos:
1. Comment Retrieval:
– Use the YouTube Data API to scan all our videos for comments.
– Identify and highlight comments that we have not replied to.
2. Google Sheets Integration:
– Output the data into a Google Sheet with the following columns:
– Comment Date-Time
– Video Title
– Video URL
– User’s Comment
– User’s Account Name
– User’s YouTube URL
– A column for our reply
3. Automated Comment Posting:
– Implement functionality to post replies based on what we write in the reply column of the Google Sheet.
– Include a dropdown or button in the sheet to trigger the comment posting, labeled as “Post Comment” or “Go.”
B – Managing Mentions in Other Videos:
1. Retrieve Mentions:
– Gather all videos where our channel is mentioned, as found at https://studio.youtube.com/channel/[channel ID]/activity/mentions.
– Check if we have left a comment on these videos.
2. Google Sheets Integration:
– Output the data into a Google Sheet with the following columns:
– Upload Date-Time
– Video Title
– Video URL
– User’s Comment (if any)
– User’s Account Name
– User’s YouTube URL
– A column for our reply
3. Automated Comment Posting:
– Implement functionality to post replies on mentioned videos based on what we write in the reply column of the Google Sheet.
– Include a dropdown or button in the sheet to trigger the comment posting, labeled as “Post Comment” or “Go.”
Requirements:
– Strong experience with the YouTube Data API and Google Sheets API.
– Proficiency in a relevant programming language (e.g., Python, JavaScript).
– Ability to automate workflows and manage API integrations.
– Clear documentation of the code and instructions for future maintenance.
Deliverables:
– Fully functional automated script/system as described above.
– Documentation on how to use and maintain the system.
– Initial setup and testing on our YouTube channel and Google Sheets.
Project Budget:
Please provide your estimated budget and turnaround time for this project.
How to Apply:
– Share your relevant experience with YouTube API and Google Sheets integrations.
– Provide examples of similar projects you have completed.
– Outline your approach to this project, including any potential challenges you foresee.
Posted On: August 12, 2024 00:23 UTC
Category: Scripting & Automation
Skills:Google Sheets, Google Apps Script, API, Google Cloud Platform, Python
Country: Australia
click to apply
Powered by WPeMatico
