+ Reply to Thread
Results 1 to 2 of 2

Google Sheets - Pulling Public Data from Social Media

  1. #1
    Registered User
    Join Date
    03-24-2023
    Location
    AZ, USA
    MS-Off Ver
    Version 2302 Build 16.0.16130.20298
    Posts
    1

    Google Sheets - Pulling Public Data from Social Media

    I'm attempting to build a Google Sheets database to showcase publicly available information from social media accounts in order to help a brand grow their online presence. I also understand that due to the limitations of Google Sheets, the values in the cells will not update in real time, instead only updating upon reloading the page. This is acceptable. I've attempted a few different formulas, but I've never had to pull information from a social media website before and I'm unsure of what to do.

    The information I'm attempting to track is as follows:

    Date of Account Creation
    Date of Most Recent Post
    Average # of likes per Post
    Average # of comments per Post
    Highest # of likes on a Post to date
    Highest # of comments on a Post to date

    Any ideas of where to go from here? Any and all help would be appreciated :P

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,052

    Re: Google Sheets - Pulling Public Data from Social Media

    You could try the IMPORTHTML and IMPORTXML functions.
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  2. [SOLVED] Video Posted on Social Media
    By krisimonelo in forum Word Formatting & General
    Replies: 0
    Last Post: 02-04-2018, 12:05 PM
  3. Inserting Social Media Logos
    By SAJ87 in forum Excel General
    Replies: 1
    Last Post: 01-13-2016, 07:31 AM
  4. Social Media Forecasts Using Excel
    By bert2015 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2015, 09:56 AM
  5. [SOLVED] Need a graph wizard - social media data
    By guy13 in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 11-07-2014, 11:43 AM
  6. Need a graph wizard - social media data
    By guy13 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-07-2014, 09:18 AM
  7. Need a macro for social media channel data collection
    By abu0022 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2014, 02:08 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1