integrating API with Google Sheets

[Katie Baildon]

Hello, 

I'm new to the group and not a developer. I work for a nonprofit and am tasked with figuring out how to add NY state and federal legislative district info to our membership database to facilitate more targeted advocacy campaigns. We use Salesforce and options for automating district info using products in the AppExchange are too expensive. So, I'm hoping to actually avoid doing anything in Salesforce. Instead, I'm wondering if there's a way to use this API to update a Google Sheets (or Excel) spreadsheet of physical addresses. So I have a list of my member's addresses, can I create columns for congressional district #, state assembly district #, and state senate district # and somehow use the API to populate those columns?  

I hope this makes sense! If anyone can point me to some documentation about how I might do this or tell me it's impossible, I'd greatly appreciate it!

Katie 

[KYP, LLC]

Hi Katie,

It might be helpful if we spoke. I think what we built should be able to assist. We built a search engine to allow for voters to find out who represents them. It could be repurposed to support this. 

Regards,

Evan Higgins

Co-Founder

Know Your Politician (KYP, LLC)

ehig...@timetokyp.com

Follow us: Instagram | Twitter | TikTok

[Sudipta Chatterjee]

Hi Katie,

 You can use Google sheets to interact with any API, not just the Civic Info API, as per guidance here: https://developers.google.com/apps-script/guides/services/external.

 Keep in mind, though, that if you directly embed the API key in the GET request, it will be visible to everyone who has access to the sheet. It might be more prudent to make the API calls from a private spreadsheet, and then copy and paste the values (or set up periodic syncs) with the shared spreadsheet.

Warm regards,

Sudipta

                                                                                                  

•  Sudipta Chatterjee •  agent...@google.com •  Technical Solutions Consultant •  gTech Users and Products, GBO •  Normal is boring

--
You received this message because you are subscribed to the Google Groups "Google Civic Information API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-civicinfo...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-civicinfo-api/bfd59458-64ce-4721-9972-afe986c0c8d2n%40googlegroups.com.