Hi. Newbie here.
I just built out a workflow and then realized that it contains 3 different manual imports that won’t always be updated at the same time. So, I’m thinking I need a workflow for each import so it can run on it’s own. But on occasion I will need to combine all 3 workflow results and run them together.
Can you pull from different workflows as an import source (without running and exporting), or would I need to export the results of each workflow as a file and then reimport it as a source in a different workflow to combine the 3?
Also, when I run a workflow and export a file to google sheets does it export a new separate file each time, or does it overwrite the last export file, or can you append the new export data to the last export data?
Sounds like you want 3 flows, 1 for each import, and have them sent to a Google Sheet. Then create a 4th flow that pulls in all 3 Google Sheets to then work with them together.
When you send to Google Sheets, it overwrites or appends to the same Sheet in the same File each time, but can be set to create a new file each run if that is desired.
Thanks!
I just realized that I need to compare the new data to the already exported data (master database) to remove duplicates before doing a new export. Is that another workflow?
Or, can I do an initial run to start gathering the “master database” and then edit the workflow to run through that file to find duplicates? This master database will be an export that is appended to each time the workflow is ran, but I would like to eliminate duplicates before doing a new export. If the exported master database file is in the middle of a workflow does it still automatically update?
I would just handle it in the same flow. One of your imports should be the Pull from Google Sheets step and then you can use our newly improved Find overlap step to compare your two lists to identify the new rows that don’t yet exist in the “master database”.
You would then send just those new rows into the Send to Google Sheets step to append to your existing sheet.
Yes, you can! This is a really simplified flow to explain generally how to set this up. When the Parabola flow runs, it’ll pull in the most updated version of your Google Sheet and then append new rows to it at the end of your flow.
For your second question about exporting different reports to different tabs, yep, you can handle it in a Send to Google Sheets step. You’ll see that the Send to Google Sheets step has 2 arrows (tables) feeding into it).
When click to configure the Send to Google Sheets step, you’ll be able to select which sheet we should send each of the inputs too.
Just ran my first flow - very exciting!!
Everything worked well expect the export for the google sheet. I got “Error: Missing required parameters: range”
Looking back at your screenshot, I don’t have the drop options to choose “CSV 1” or “CSV 2” to go into input 1 and input 2 respectively. I only have “sheet 1” as my option in all 5 inputs. I’m guessing this is the range issue, but I don’t know how to get it to recognize the different inputs so that I can choose them.
