I have a website that I'm getting ready to launch ([url removed, login to view]). As part of that, I'm trying to prepare something to handle the social media aspect. The tools that I see out there either don't provide me with what I'm looking for, or are too expensive for the state that I'm at.
I would like is a program or webpage that will connect to a Facebook & Twitter profile that I've set-up for Music-Rater (for Facebook, it's a Facebook page in addition to a profile). Whenever I get a notification, I would like for a new line to be added to a Google sheet. I've set-up a google drive account that I would like to be used for this sheet. I've attached an excel file laying out the columns for how I would like the information displayed.
The columns in the Excel file are as follows: Website, Username, User URL, Notification Type, "On?", "Not. Text", and "Date/Time". The information for "Website" would be either "Twitter" or "Facebook". In the next two columns, I would like both the name and the URL of the person who created the notification. For Notification type I would like the type of notification listed. The different types for the two networks are: Like, Share, Message, Retweet, Mention, Follow, or Comment. If it is a comment, then I would like the "On?" column to list out if the comment is on a post, on a picture, or on the wall. If possible, I would like this column to be a hyperlink to the original comment location (post, picture, etc). If the notification is a Message, Mention or comment, then I would like the text of this notification to be captured in the "Not. Text" column. Finally, I would like the date & time of the notification captured in the final column.