Google Sheets / Tables Show Twitch Followers?

Na
- in Twitch
1

For example, I'm trying my channel: MrNyboTV to show the number of followers in my google sheets so Google Sheets file.

So my idea is. In C3 the name is entered. Then in D3 the number of followers is displayed in E3 the link to the channel and in B3 the picture of the channel in 64x64 or 32x32 format. Then in A3 will be shown whether live or not.

Nobody needs to tell me this is not possible. This works out. I know that 100% because I had that schonmal. However, I do not have the file anymore and it was years ago.

Na

So I have it like this:

From A to F:
Status - Image - Name - Follower - Link - Confirmed

So. Now if at "Name" now "MrNyboTV" is written in at "Link" The link with the name will be written. Say how I solved it now like this: = IF (F3 = "Confirmed", VERKETTEN ("https://twitch.tv/%22; C3))

That if in C3 (name) another name stands then the link stands there. Without that everything has to be changed.

Now it should be like that in "picture" The picture of the channel is (no obligation) In follower the number of followers stands and in status is whether the channel is live or not. And I emphasize again. NO MATTER! Which name is in C3. Sure, if the name does not exist, it will not work. But is there now z.b. Pewdiepie in it should be the number of followers and live status to be seen by him. I change ONLY in C3 the name to my "MrNyboTV" then my stuff is there. Reason is I have a form. Since my users can register as streamers. And image and link, etc. Everything should be entered automatically without me having to do something.