Toolio

Toolio supports Merchandise Plan and Item Plan exports to Google Cloud Storage. From there, you can also set up automated transfers directly into Google BigQuery. Please find instructions below for setting up the integration

Setup prerequisites in Google Cloud Storage:

Complete these steps first in Google Cloud Storage to prepare for the integration configuration in Toolio:

Navigate to <code>IAM &amp; Admin &gt; Service Accounts</code> in Google Cloud.

Click <code>Create Service Account</code>. - Give a name to the service account and skip the optional steps, click <code>Done</code>.

Open the service account, go to <code>Keys</code> tab, click on <code>Add Key</code>, select <code>Create New Key</code>. Generate the key in json format.

Navigate to the destination bucket you want the Toolio files to be exported to. Go to <code>Permissions</code> tab, click <code>Grant Access</code>.

Write the email address of the service account to <code>New Principals</code>.

Under <code>Assign Roles</code>, select <code>Storage Object Admin</code> role for <code>Cloud Storage</code> and click save.

1. Navigate to <code>IAM &amp; Admin &gt; Service Accounts</code> in Google Cloud.
2. Click <code>Create Service Account</code>. - Give a name to the service account and skip the optional steps, click <code>Done</code>.
3. Open the service account, go to <code>Keys</code> tab, click on <code>Add Key</code>, select <code>Create New Key</code>. Generate the key in json format.
4. Navigate to the destination bucket you want the Toolio files to be exported to. Go to <code>Permissions</code> tab, click <code>Grant Access</code>.
5. Write the email address of the service account to <code>New Principals</code>.
6. Under <code>Assign Roles</code>, select <code>Storage Object Admin</code> role for <code>Cloud Storage</code> and click save.

After you have completed the steps above, navigate to <code>Toolio &gt; Settings &gt; Integrations</code>, click <code>Add</code>, and select <code>Google Cloud Storage</code>. You will then be prompted to enter the following:

Bucket Name - the name of the bucket you want the files to be uploaded, referenced in Step 4 above.

Credentials - the contents of the downloaded key file. Simply copy and paste the contents in the json file in Step 3 above into this box. ​

- Bucket Name - the name of the bucket you want the files to be uploaded, referenced in Step 4 above.
- Credentials - the contents of the downloaded key file. Simply copy and paste the contents in the json file in Step 3 above into this box. ​

After you've created the GCS integration in Toolio, you can then navigate to <code>Settings &gt; Exporters &gt; Add</code>. You can then select <code>Google Cloud Storage</code> from the menu. ​ From there, you can select the GCS integration you just created and configure the Source Settings and export Schedule. You can read more about export configuration <a href="" rel="nofollow noopener noreferrer" target="_blank">here</a>. ​

Setup prerequisites in Google Cloud Storage:

Create a new GCS integration on Toolio