TABLE OF CONTENTS
- 1) Description
- 2) Setting up the Tasks
- 2.1 Task 1: Source to Google Sheets
- 2.2 Task 2: Google Sheets to Target
1) Description
Some integrations do not support Incremental Imports while it can be necessary to achieve the desired workflow.
Therefore a custom workaround can be created through Google Sheets to make Incremental Import possible.
2) Setting up the Tasks
2.1 Task 1: Source to Google Sheets
2.1.1 Create task 1
Source
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3083869443/original/jpWcNM7fl2jISKhV1BTjjCJo-VQB5kOh7g.png?1658243471)
The Source can be any Integration that does not support incremental imports in the configuration.
Target
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3083869435/original/NfEHD5PEegT9dMkY055Mk8IKJ4GUFHEFAg.png?1658243471)
This workaround would require the use of the Google Sheets integration
If you do not have this set up already please proceed with the setup according to How to integrate Google Sheets
2.1.2 Target Configuration
To make the Incremental Import possible the following Configurations have to be applied to the Google Sheet.
Export behavior
Update or Create using UID
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3083869441/original/2spQ3ucJsI31DvxAyIHh8FzgxKVHdotbDg.png?1658243471)
Action: Only Create
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3083869444/original/QJVhLIyR9r2DTJJDhO9zU6TLRtlhSZ4skQ.png?1658243471)
Create Required data Fields
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3083869440/original/LO3b0w3r5p-CrG4OtmaXO8ONYT39Qjkz6Q.png?1658243471)
Here the Data fields imported from the Source should be added so that they can be passed on to the Target integration in Task 2
Set UID field
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3083869439/original/10VuaXPsEbFJTuhAkjM2TMcBjg2vVyZdJA.png?1658243471)
Setting a column as UID (Unique Identifier) will serve as reference to system on checking for updated records.
You need to specify which columns should be treated as unique. The system will use this when checking for updated records.
At least one column must be selected.
Overview of Config example
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3083869446/original/_XLjcXgG0fKizxwoXsQiWTf4c5FmDafjzA.png?1658243471)
2.1.3 Task Setting: Trigger
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3083869431/original/_LuSby_4DcmfgM6UcTb1Z6ys_KBVhZGn0A.png?1658243468)
The Trigger can be set up as desired.
For all the trigger options please consult:
Task Settings Section 4) Task Automation
2.2 Task 2: Google Sheets to Target
2.2.1 Create Task 2
Source
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3083869434/original/DD1FJGU25Bx_HWzT3rkleGERJwi05VhYsg.png?1658243470)
The Source for this task will have to be Google Sheets, specifically the sheet that was created in Task 1 needs to be used.
Target
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3083869436/original/pBcsq85SqfpbN12L8F8TbmzuBhob_NGjZQ.png?1658243471)
The Target for this task should be the Integration you desire to transfer the date to fetched from the Source in Task 1
2.2.2 Source Configuration
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3083869437/original/HkRhvzK1GXSGR9fznNsa7e_PrWeeGS6brA.png?1658243471)
Record Processing: Update Records
During task execution the system will compare the current file with file from previous execution and only added and/or changed records will be sent to the destination.
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3083869442/original/92HvOZ07i_c239SOKl8YI4jHY_C_5t6R8w.png?1658243471)
Unique Column
A Unique column has to be selected, this should be the same as the column marked as UID (Unique Identifier) in Task 1
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3083869445/original/qNDfcLXwe2M4nBxfNhp-GvHJsZVM1dHbVA.png?1658243471)
2.2.3 Task Setting: Trigger
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3083869438/original/uz1OhAJVnwD008EHL_hnakkwRHmQ0cJFgQ.png?1658243471)
Triger: On event
When: Task Succeeded event
Task: Task 1
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3083869447/original/SZlE4ec7VYfWzMPLlVV6ewXgGNv1T33fbQ.png?1658243471)
This has to be selected in order to execute the task as soon as Task 1 has been completed.
This is selected so that the incremental import does not need any manual intervention.
We hope that this covers everything. If you have any further questions or need additional clarification please reach out to us via [email protected] or our Chat Widget!
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article