Fundraise Up REST API - Looker Studio Connector

This repository contains a community connector script to fetch donations data from FundraiseUp and visualize it in Looker Studio using Google Apps Script.

For a detailed walkthrough of Fundraise Up REST API, check out documentation.

Features

• Fetch dynamic donations data based on API key input.
• No authentication required.
• Seamlessly integrates with Looker Studio for data visualization.
• Google Sheets Support - automatically adds new rows to the sheet.

Usage

Setup in Google Apps Script

• Create a new Google Apps Script project.
• Copy and paste the provided script into the editor.
• Save and deploy the script as a web app.

Integration in Looker Studio

• Use the deployed script URL as the data source in Looker Studio.
• To obtain API key open Fundraise Up Dashboard > Settings > API keys and click Create API key.
• Configure the data source by specifying the desired API key.
• Visualize the fetched data using Looker Studio tools.

Connect Google Spreadsheet

• Create empty Google Sreadsheet and copy ID from URL.
• Edit config params in the SpreadSheet.gs file, paste the spreadsheet ID and sheet name.
• In your Apps Script project, at the left, click Triggers⏰, at the bottom right, click Add Trigger, select and configure the time-driven trigger which will run function runScheduledTask()
• You can also use your spreadsheet as a data source in Looker Studio.

Schema

Supports 100+ fields declared in documentation. Do not support questions field.

Example

Example of data visualize by Looker Studio report.

License

This is an unofficial project made for educational purpose. Licensed under the MIT License. See the LICENSE file for more details.