How to Use Look Up Table Action for Infinity inside Pabbly Connect

Learn how to integrate Google Sheets, Infinity, and more using the Look Up Table Action in Pabbly Connect with this detailed tutorial. Master proven automation processes with practical implementation examples and strategic recommendations you can apply immediately in your workflow.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start using Pabbly Connect, navigate to the official website by typing ‘Pabbly.com’ in your browser. If you’re a new user, click on the ‘Sign Up for Free’ button to create your account. Existing users can simply sign in to access their dashboard.

Once logged in, locate the ‘All Apps’ section and select Pabbly Connect. Here, you will create a new workflow for integrating Google Sheets with Infinity using the Look Up Table action. Click on the plus sign to create a workflow, and name it appropriately, such as ‘Use Look Up Table Action for Infinity inside Pabbly Connect.’

2. Setting Up Google Sheets as a Trigger Application

In this step, you will set Google Sheets as the trigger application in Pabbly Connect. Select Google Sheets and choose the trigger event as ‘New or Updated Spreadsheet Row.’ This setup allows Pabbly Connect to monitor your Google Sheet for changes.

• Copy the webhook URL provided by Pabbly Connect.
• In Google Sheets, go to Extensions > Add-ons > Get Add-ons and search for ‘Pabbly Connect Webhooks.’
• Install the add-on and refresh your Google Sheet.

After refreshing, navigate back to Extensions, select ‘Pabbly Connect Webhooks,’ and click on ‘Initial Setup.’ Paste the copied webhook URL and set the trigger column, which is usually the last column where data updates occur. Click on ‘Send Test’ to verify the setup.

3. Integrating Infinity with Pabbly Connect

Next, you will integrate Infinity into your workflow using Pabbly Connect. After setting up Google Sheets as the trigger, add an action step and select Infinity as the application. Choose the action event ‘Get Attributes’ to retrieve necessary attribute IDs from Infinity.

Connect your Infinity account by clicking on ‘Connect’ and authorizing Pabbly Connect. Select the appropriate workspace and board where your data is stored. This step is crucial because it allows Pabbly Connect to access your Infinity data.

• Select the correct workspace and board in Infinity.
• Map the attribute IDs from the Google Sheets trigger response.
• Click ‘Save and Send Test Request’ to retrieve the attribute IDs.

This step is essential for ensuring that Pabbly Connect can match the data from Google Sheets to the corresponding entries in Infinity.

4. Using Look Up Table Action in Pabbly Connect

Now, you will utilize the Look Up Table action in Pabbly Connect to map the attribute IDs retrieved from Infinity. Add another action step and select ‘Lookup Table’ as the application. This action allows you to create a mapping between the status labels (like paid, failed, refund) and their corresponding attribute IDs.

Map the status from the previous steps to the lookup key in the Lookup Table action. Enter the labels and their corresponding attribute IDs. After configuring the lookup table, click on ‘Save and Send Test Request’ to validate the mapping.

Define labels such as ‘paid,’ ‘failed,’ and ‘refund.’ Map the corresponding attribute IDs for these labels. Ensure the lookup key accurately reflects the status from the Google Sheets trigger.

This process ensures that the correct status is updated in your Infinity table when changes occur in Google Sheets, facilitated by Pabbly Connect.

5. Updating Infinity with the Mapped Data

Finally, you will update the Infinity table using the mapped data from the Lookup Table action in Pabbly Connect. Add another action step and choose Infinity again, but this time select ‘Update Item’ as the action event. This step will apply the changes from Google Sheets to your Infinity table.

Connect to Infinity and select the workspace and board as previously done. You will need to map the item ID from the search item action to ensure the correct entry is updated. Map the status column to the value retrieved from the Lookup Table action.

Select the correct item ID to update. Map the status field to the updated attribute ID from the Lookup Table. Click ‘Save and Send Test Request’ to finalize the update.

Upon successful execution, your Infinity table will reflect the updated payment statuses from Google Sheets, demonstrating the power of Pabbly Connect in automating your workflows.

Conclusion

In this tutorial, we explored how to use the Look Up Table action for Infinity inside Pabbly Connect. By following these steps, you can seamlessly integrate Google Sheets and Infinity, ensuring that your data remains synchronized and up-to-date. This integration not only saves time but also enhances data accuracy across your applications.