A client needs to get donation data into a spreadsheet immediately in real-time. I see the transations API is does not give access to critical (to us) information such as: billing first name or last name, and "title" from the donations block form. When I pull the data into a spreadsheet via Make, the only relevant data I can get is email address and total donation. So it's fairly useless for our use case.
Any suggestions for creative ways around this? Third party options? I looked at Donorbox but to access that data via API is out of their budget. I thought perhaps using the Squarespace services option in products, but the service amounts are static and I don't see a way to let the customer choose what they pay. The essential requirements are:
1. Lets people choose any amount to give
2. Auto-populate a spreadsheet with donor name, associated donation block title, donor email, and total donation