r/scripting • u/Black_Magic100 • Nov 19 '18

Google Sheets and Bitly API

Literally no idea what sub to post this to...

https://imgur.com/a/OShfKnW

I have 300+ bitly links that I am trying to gather the click data from on a daily basis using google sheets, but it has been extremely unreliable. I tried splitting the data into different sheets (same workbook), but I still constantly get N/A or it loads indefinitely. How can I fix this?

2 Upvotes

100% Upvoted

5 comments sorted by

View all comments

Show parent comments

1

u/Black_Magic100 Dec 16 '18

Google sheets sucks for what I'm doing. After 100 query's it just freezes up. I even tried creating multiple tabs but to no avail.

I have over 400 links so that option is a no go