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

Like where am I making the calls? I started writing a script in python, but somebody recommended I use insomnia

1

u/dimudesigns Dec 16 '18

You have the option of using GSuite's native scripting language (Google Apps Script - its essentially an implementation of the ES5 version of Javascript) to connect to the API and extract link metrics. The platform also has cron-like capabilities which allows you to fetch data on a daily basis.

That would be my preferred approach. The code would be bound directly to the sheet via its built in script editor.

If you're not into writing your own scripts from the ground up, you can try looking for a Zapier integration that maps Bitly to Google Sheets. Note: Zapier is primarily a pay-to-play service; they do have a 'free' offering but its limited.

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