Automate Export and email
Hi, I am trying to automate the process below:
1 - Schedule export with CSV from Card from DOMO
2 - Receive CSV via email
3 - Automatically send the CSV to a virtual inbox which will upload my CRM (Hubspot)
My issue is at step 3 as Gmail does not allow me to set up an automatic forward to a virtual inbox, need validation via clicking on the link.
Do you have any other suggestion to achieve the objective described in the process, it could be an integration, a script, or anything you think can help us (i.e. Dropbox, Box, etc..)
Many Thanks,
G
Comments
-
Take a look at Zapier.com
Here's a tutorial going the opposite direction, but the concepts are similar
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Rather than trying to set up automatic forward from your own email, you should be able to add the email address for the virtual inbox to the scheduled report distribution list.
0 -
G,
Is the virtually generated email address from Hubspot? If so, can you access the inbox in any fashion? For example, in Domo, you can change the DataSet-via-Email URL to manipulate it into downloading an email message. There have been several times where I setup a DataSet-via-Email job in Domo where the data source required me to acknowledge an email before it would deliver any scheduled reports to Domo's inbox. I imagine Hubspot my have a similar mechanism if you reach out to their support team.
Otherwise, Domo has several options to extract data out of Domo to feed into other sources but they are mostly premium features (writeback connectors). If this kind of use case is common or may become more common, then I'd personally recommend standing up a lightweight MySQL/PostgreSQL database instance on the cloud provider of your choice and look into signing up for the MySQL or PostgreSQL writeback connector. Once you have this enabled you can fetch any data you want out of Domo gracefully. We do this for writing back data to our email marketing platform.0
Categories
- 7.7K All Categories
- 5 Connect
- 921 Connectors
- 244 Workbench
- 477 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 446 Datasets
- 40 Visualize
- 199 Beast Mode
- 2K Charting
- 8 Variables
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- Workflows
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 15 Manage
- 36 Governance & Security
- 28 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 14 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部