rodrigolaa/spotify-project

Get daily top 50 musics in Spotify and use it to create analyses in Data Studio. :musical_note:

Spotify Project

This project aims to create Looker Studio Dashboard with the top 50 tracks in the world. The data was retrived using a Python script that consumers the Spotify API and uses a Lambda Function to register the dta in a Google Sheets.

Dashboard.

What I have learnend?

• How to create a google api.
• How to create a spotfy api.
• How to develop a python script to retrive API information and parse through JSON object.
• How to deploy ZIP file in AWS Lambda Function with AWS CLI.
• How to Set a EventBridge cron job in AWS Lambda Function to run every day.
• How to ccreate a free, online and analytical dashboard in Looker Studio.

1) Get Spotify Credentials in here

 Need To create an App, put a name and description for it, and you are good to go!

2) Get Google Sheets API - Google Cloud

 - First you need to create an account in Google Cloud
 - then, Create a Project
 - Create an Google Sheets API
 - Share the google sheets with the email generated with the Google Sheets API.
 - Save the credetials json file in the folder of the project.

For more details in how to configure the Google API watch this video: tutorial

3) Create Python Deployment Package (.zip) with all packages and code.

4) Upload the .ZIP file in a AWS Lambda Function with AWS CLI.

5) Set a Cron job with EventBridge alarm every day.

For more details, follow this Tutorial

Thanks!