GoogleSheet Widgets for JustGiving

The purpose of this application is to provide widgets that pull data from a Google Sheet to provide data and functionality not available in JustGiving. This includes the following:

  • Campaign Tiles, including Tiles that contains a dropdown list of multiple different campaigns and an offset field for adding offline gifts
  • Donation ticker that includes Offline Donations
  • Donor honor roll that includes Offline Donations
  • Metrics that calculate total raised and number of gifts from JustGiving (across all campaigns added in the campaign tiles sheet) and calculating from the Offline Donations entered in the Google Sheet. A formula is set in the template to calculate the offset values by matching the name column in the campaigns tab with the funds column in the offline gifts tab.
  • Progress meters that calculate total raised and number of gifts from JustGiving (across all campaigns added in the campaign tiles sheet) and calculating from the Offline Donations entered in the Google Sheet.
  • Leaderboards across muliutple campaigns based on number of donations that will factor in offline gifts enetered into the Offline Donations tab of the Google Sheet.

The first step will be to create a Google Sheet and publish on the web. You can follow this template as a guideline. Directions and examples below on implementing a widget.

The first tab needs to be Campaigns, while the second must be Offline Gifts.

Tab 1 - Campaigns

List all campaigns you want to include as tiles along with the campaign id and mark the display as tile.

Next include the tiles you want as dropdown lists and set display as dropdownTile. Do not set the id for these as they are just placeholders meant to group campoaigns together in one tile. For the campaigns you want to inlcude in the dropdown, set display to dropdown and make sure to set a dropdownGroupId so you can group your dropdowns with this tile.

Make sure to also include title, story content, image on JG server, and target (if you want to override what pulls from JG).

You can also set a tile as a feature tile, meaning it will be full width. For this to work best make sure the image used matches the other tile image dimensions.

In addition, you can override default column width (which is 25% so four tiles in a row) by setting column width as a percentage. This will set the column width at the largest breakpoint.

You can set the type of tile to show number of donations rather than amount raised. There is also an offset field, which can be used to manually add to the amount shown (ie for offline gifts).

There is also an offset column available. The template already has a formula in place to test if Fund Name in Offline Gifts tab matches the name of the tile and inlcudes the offline gifts automatically.

Tab 2 - Offline Gifts

To include offline gifts in tickers and honor roll make sure to include the donor names. If no gift date is included, then those entries will be added to the back end of the ticker (the ticker runs from most recent to oldest).

To automatically include offline gifts added to specific tiles fill in the Fund Name and have it match the name of the tile you want to add the offline gift to.