Salesforce Data Connector

Hey everyone I’m working on a data connector that simplifies the process of connecting data from various sources to Google Sheets for a hackathon! The aim is to drastically reduce time for analysts in sales to generate the right data for reporting. Some things I’d love to add is: 1. Connect & keep your sheets automatically in sync with company systems so your dashboards and reports are always fresh. 2. Add filters and dynamic filters (via references to spreadsheet cells) to import only the data relevant to your analysis 3. Data refreshes preserve formula references and copy-down formulas so your sheet continues to work with ever-changing data 4. Set custom triggers to monitor the imported data or any cells in your sheet to notify you on Slack or email of relevant changes 5. Push updates back to the data source from the spreadsheet If your interested in following my journey I’d really appreciate you feeling out this form so I can keep you updated on the process and periodically ask what you’d like to see! https://forms.gle/dx8tcL2ETeGjwmt26 #dataanalyst #dataconnector #salesforce

Tableau vorS11 Jan 22, 2023

You are talking about a primary use case of Tableau. It just can't get to Marketing Cloud data easily without additional purchases.

Tableau vorS11 Jan 22, 2023

You can build all those line items in a few hours.

Pinterest GG WP Jan 22, 2023

I am actually looking for an engineer who can build this for multiple tech stacks - I have this startup idea (coming from my RevOps job) and all product requirements + mock ups ready (just can't build it)

Microsoft Mr19 OP Jan 22, 2023

Wow really interesting maybe we can speak I’d love to learn more?

Pinterest GG WP Jan 22, 2023

I have sent a message

Salesforce wbqE75 Jan 22, 2023

Building it isn’t the big challenge. Getting infosec approval at enterprise level is. Who is the target market? I’ve spent months with a FAAMG trying to get 6 data elements replicated from one system to another. Maddening.

Microsoft Mr19 OP Jan 22, 2023

I was thinking that the user would be an analyst who wants to save a lot of time moving data out of tools like salesforce into google sheets for reporting. I thought this tool would be accessible pretty easily in like a google marketplace and wouldn’t need any enterprise level approval. Do you think that’s not possible?

Salesforce cIyT64 Jan 22, 2023

Fwiw google already has a built in connector for salesforce in google sheets