Creating Historical Product Price Records with Sheetgo
Tracking the historical prices of products is crucial for businesses to analyze trends and make informed decisions. One efficient way to manage this is by using the Sheetgo Web App to append daily product prices from one Google Sheet to another. This guide will walk you through the steps to set this up.
Step 1: Prepare Your Source and Destination Sheets
Start by organizing your data in Google Sheets.
Sheet A (Source): This should contain your current product prices. Typically, it will have columns like Product ID
, Product Name
, and Price
.
Sheet B (Destination): This will be the sheet where historical data is appended.
Ensure both sheets are properly set up and accessible.
Step 2: Access Sheetgo Web App
Go to the Sheetgo Web App website and sign in with your Google account.
Once logged in, you’ll be directed to the dashboard.
Step 3: Create a New Connection
Click on ‘New workflow’, then click on ‘Create a connection’ to start a new connection
Choose ‘Google Sheets’ as your source and select Sheet A from your files.
Step 4: Set Up the Source Details
After selecting Sheet A, Go to advanced settings, enable ‘Add new column’, then select ‘Destination file transfer date and time’, and finally choose a date format from the dropdown menu.
specify the range of cells containing your data if not using the entire sheet.
Step 5: Select the Destination Sheet
Choose ‘Google Sheets’ again, this time selecting Sheet B as the destination.
Decide whether to append the data to an existing sheet or create a new one each time.
Step 6: Configure the Append Settings
Carefully configure how you want the data to be appended. Sheetgo allows you to append below the last row, maintaining a continuous historical record.
Step 7: Finalize and Run Your Connection
Review your settings, name your connection for easy identification, and then initiate the transfer by clicking ‘Finish and save’.
Step 8: Set Up an Automatic Update Trigger
Now that you have your connection between Sheet A and Sheet B set up, you’ll want to ensure that this data transfer occurs automatically on a regular basis. Sheetgo allows you to create triggers to automate updates according to your chosen frequency. Here’s how to set it up:
Now, at the bottom left of your screen, you will see two icons: ‘Run’ and ‘Automate’.
Click on ‘Automate’ option to set up your schedule. Here, you can define how often you want the workflow to run: daily, weekly, or monthly. For tracking daily price changes, you would typically choose ‘Daily’.
Depending on your business needs, select the time of day you want the update to occur. Keep in mind the time zone settings to ensure the updates occur at the correct local time.
After setting your preferred schedule, save your changes.
By creating this automatic update trigger, Sheetgo will append new data from Sheet A (Source) to Sheet B (Destination) automatically following the schedule you specified. This ensures that your historical records are consistently up-to-date without the need for manual data transfer each day.
Step 9: Check Your Historical Data
After the connection runs, check Sheet B to ensure the data from Sheet A has been appended correctly. Over time, this sheet will grow to include historical pricing data for your products.
You can connect an external API as a source. Check out how!
Conclusion
By setting up this Sheetgo connection, you’ve automated the process of recording daily price changes for your products, providing you with a valuable dataset for analysis and decision-making. Remember, you can adjust the frequency and settings of your Sheetgo connections to fit your business needs.