donation Managing Donations outside of Squarespace Panel

Site URL: https://branchesofhope.org.hk

I'm working at a non-profit and we're updating our website on squarespace. Right now, we're having trouble managing on the donation panel. Our finance department would like the donation information to auto-populate into a Google Sheet.

Is there some kind of code or something that can do this? How are you handling the management of donations?

9 minutes ago, deannadenham said:

Our finance department would like the donation information to auto-populate into a Google Sheet. Is there some kind of code or something that can do this?

You can export donations to a .csv file so that it can be viewed in a Google Sheet. It won't auto-populate, but you can manually trigger an export by clicking Export CSV. The spreadsheet of donors will include the following:

• Donation Block title
• Donation amount
• Currency type
• Donor name (first and last name in one column)
• Email address
• Address
• Phone number (if entered)
• Time and date of donation

For more information, see Managing Donations.

   If a post helps you, please click a "Like" option below  ↘️

They are looking for a solution that is dynamic as it needs to be shared throughout the department and kept updated, edited, etc. as they are not solely using information that Squarespace provides. The exported csv is a static document. 

We've scoured the squarespace help guides and can't find anything close to this, unless there is a way to combine the form block with the donation block. That way we could use the "hidden" question to make links or use the storage option on the form block for google sheets.