I am looking for googlesheets integration with the eventbrite api. I would like to be able to run a query like this: [login to view URL]
and have the results returned into a googlesheet with each event on a single row. I would like to retrieve the following fields for each event:
[login to view URL]
[login to view URL]
[login to view URL]
id
url
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
is_free
category_id
subcategory_id
The script should create the query for me, so that it would be easy to run different queries. The parameters that I would like to be able to enter into the google sheet to create the query would be:
q
sort_by
[login to view URL]
[login to view URL]
categories
subcategories
price
start_date.range_start
start_date.range_end
[login to view URL]
include_unavailable_events
You can refer to eventbrites api documentation for more details:
[login to view URL]
Attached is a screenshot of the desired Googlesheet results.
Hello there,
As we went through your job description and understand your requirements,
We can Use Google Sheets to query Eventbrite API as per your requirements.
Please messgae us for detail discussion.
You could wrap the Eventbrite API request with Google Sheet Script Editor and set a trigger (schedule/timer, onEdit, or Onclick) for executing this wrapper. So does the response parse/extract. I could write the code for this purpose.
I have integrated various APIs in Google Sheets.
I have excellent command on Google Sheets. I have completed complex projects before. For instance
- Get live cyptocurrency data and create dashboard using coinmarket API
- Upload and Manage Videos in Vimeo using JSON API in google sheets
- Extract mails and attachments from gmail to google sheet and drive respectively
- Twitter functionality like retweet, auto-tweet, and so on
- Integrated Google Sheets, Forms and docs to create a dashboard and tracking system to track health data of individuals for a health care organization
You can see the reviews of the same in my profile