google sheets - How to Export Number of Followers from Instagram accounts to Googlesheet?

Question

I manage different Instagram accounts, some of them are private and others are business accounts. Instead of checking all of them daily, I need to list them in one Google sheet and see the number of their followers. Previously, I have used XML to fetch that. But now it is not working. Is there any way for doing this? (Also, I need this data to be updated automatically without the needs to run a code each time so other team members can see the data whenever required)

My previous sheet was this: enter image description here

question from:https://stackoverflow.com/questions/65883752/how-to-export-number-of-followers-from-instagram-accounts-to-googlesheet

Answer 1

You should use instagram api if you wanna extract your own followers First connect your instagram account to the api And then you have followers list Second write a loop statement and write the list one by one to a excel file by the way you can use free excel package for python