This addon retrieves profile and posts data from your Bluesky account and turns it into customizable tables in Google Sheet™. Schedule daily imports, track engagement, activity trends, content types, and more. 

AVAILABLE DIMENSIONS AND METRIC:

Profile Dimensions
- Username: Your unique Bluesky handle.
- Display Name: The public name you set on your profile.
- Description: Your bio or personal introduction.
- Avatar URL:  Direct link to your profile picture.
- Banner URL: Direct link to your profile banner.
- DID: Decentralized Identifier assigned by Bluesky.
- Handle: Another format of your username.
- Created At: Date your profile was created.
- Indexed At: Last time your profile was indexed by the connector.

Profile metrics
- Number of Followers: How many users follow your profile.
- Number Following: How many accounts you are following.
- Number of Posts: Total post count associated with your account.

Posts dimensions:
- Post Text: Content of the post.
- Post Date: Timestamp when the post was published.
- Post URI: Internal URI for referencing the post in APIs.
- Post URL: Public link to the post on bsky.app.
- Post ID: Unique identifier for each post.
- Post Type: Whether the post is an original, reply, or quote.
- Reply To (URL): Public link to the post being replied to (if applicable).
- Embed Type: The type of content embedded in the post (e.g., image, link).
- Embed URL: URL of the embedded content.
- Thumbnail URL: Link to a thumbnail image (if available).

Posts Metrics
- Likes:  Number of likes a post has received.
- Replies: Number of replies to a post.
- Reposts: Number of times the post was reshared by others.
- Quotes: Number of times the post was quoted by others with a comment.
- Engagement Score: Sum of likes, replies, reposts, and quotes. Reflects total interactions.
- Media Count: Number of media elements (images, videos) in the post.
- Thread Depth: Level of nesting in a conversation thread (i.e., how deep a reply is).

3 SCHEDULING IMPORT OPTIONS:

1/ Replacing all the previous data
2/ Adding the new data below the existing one
3/ Updating the existing data and adding the new one below. If you select this option, you’ll need to indicate the unique column you wish to use to recognize the existing data, so that the system understands if the data already exists or needs to be added.

3 IDENTIFICATION STEPS:

1/ Enter your Bluesky handle. You’ll find your Bluesky handle at the top of this page https://bsky.app/settings after logging into your Bluesky account.
2/ Enter your Bluesky App Password. To create your Bluesky App password, visit https://bsky.app/settings/app-passwords and click on the « Add App Password » button. Enter a name and click « Next ».
Copy the password (« e.g. xxxx-xxxx-xxxx-xxxx ») and paste it into the connector’s App Password field.
3/ Get your license key here https://digitaldataschool.com/bluesky-license/. Your free license gives you unlimited access until June 30, 2026. A fair pricing model will be decided collaboratively with early users before the end of the year.

Learn more:  https://digitaldataschool.com/bluesky-insights-google-sheets/

Google Sheets™ is a trademark of Google LLC.