We use another software to start our request for proposals. Right now I take some of that information and manually create an opportunity in Copper. Sometimes the company and main contact already exist in Copper, sometimes they are new. But I still do this manually, is there a way I can import the data once a week into Copper?
Hello
I understand how manually creating and updating records can get tedious, and I think I may have the solution for you :). What software are you trying to import automatically from? In most instances, we can use Zapier to automate (with “zaps”) the sharing of information between Copper and another app (or site).
If you’re not trying to import from that software (or if it’s not a software currently supported by Zapier), please see my instructions below.
Please check out this article on “How to update on import (aka manage matching records)”.
When you update in this way, a few things are considered.
- Checks if that record exists in the system, based on the key field (more on that below)
- If that record does not exist, it will create it for you
- If that record does exist, it will either skip (i.e. ignore) it or overwrite with the data in your spreadsheet, depending on your settings.
The most important thing here is the key field; this is the unique piece of information that Copper will use to search for existing records and for Opportunities it is the opportunity name by default. But you can select a different field key in the process. Here is a list of key fields you can use with Opportunities:
You can find the information above, and more, in this other article on “Update Records on Import”.
Also, the articles linked also include information on the other record types in case you were curious about the “what” and the “how” on those as well.
Hope that helps, otherwise please let me know if I can provide additional info or answer another question you may have regarding this!
Best,
Thanks so much
I’ll try to read through some of the links you shared and see if I can figure this out.
Thanks again,
ARCO
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.