Flow Library

Suggest new keywords with ChatGPT and export them to Google Sheets

In this streamlined process, leverage ChatGPT to generate a curated list of 20 fresh keywords. These keyword suggestions are intelligently generated by analyzing your existing keywords and ad copy as a starting point. Once generated, they seamlessly integrate into a Google Sheets document for your review and validation. Take full control as you manually review and decide to either retain or remove these suggested keywords within the Google Sheets interface. This meticulously curated keyword list becomes a valuable reference point for your subsequent workflow, enabling the effortless addition of keywords from Google Sheets to their respective AdGroups.

Add 20 keywords suggested by ChatGPT to ad group from Google Sheets

This seamless process involves the addition of 20 keywords, thoughtfully recommended by ChatGPT, directly to their corresponding ad group. Subsequently, these keywords are efficiently transferred to a designated Google Sheet for future reference, streamlining your workflow by ensuring organized keyword management.

(PMax) Campaign performance monitoring - ROAS based corridor

With this flow one can monitor the campaign performance and get notified if the performance does not stay within certain thresholds. The flow compares the campaign level performance (ROAS) of the past 7 days with the average of the last 14 days. The basis for this comparison is a corridor of ± 30% of the average cost and conversion value of the last 14 days. Of course these thresholds can be individually adjusted. A message is sent if either costs, or conversion value or conversion value and costs are out of this set boundary. The message features the campaign name, sheds light on whether costs, conversion value or both values are out of target and features the set corridor values.

Suggest new descriptions for MC with ChatGPT

This workflow empowers you to generate fresh product descriptions for your Merchant Center listings by harnessing the power of ChatGPT. Leveraging the inherent characteristics within your product feed as a foundation, ChatGPT crafts compelling descriptions. These descriptions are seamlessly exported to a Google Sheet for your review and approval, facilitating a streamlined process for enhancing your product listings. It's worth noting that if any essential feed attributes required for the ChatGPT prompt are missing, the workflow will encounter an error and be deemed unsuccessful for those specific products. However, products with complete attribute data will still have their descriptions readily available in the Google Sheet, irrespective of any temporary issues, ensuring an efficient workflow.

Add product description by ChatGPT to MC from Google Sheets

This workflow involves the addition of product descriptions, thoughtfully generated by ChatGPT, directly to their corresponding products within the Merchant Center. Subsequently, these descriptions are efficiently transferred to a designated Google Sheet for future reference, ensuring organized and easily accessible documentation of your product descriptions.

Best performing KW detector (last 30 days)

Receive a weekly notification about your best performing keywords of the last 30 days. The threshold can be individually set based on conversions, conversion value, ROAS or any other KPI and combination of KPIs.

The output is a slack notification informing the reader about the best performing KWs including performance information. This might look like this: “The KW ‘YOUR KEYWORD’ belongs to your best performing KWs. The KW has 12 conversion(s) within the last 30 days. You might want to use our ChatGPT flow to explore new keywords.”

Best performing KW report to sheet

The best performing KWs are reported to a Google Sheet featuring various performance indicators such as clicks, conversions, impressions,... informing one about the performance per keyword. Get notified once the update is performed.

Best performing item report to sheet

The best performing item (IDs) are reported to a Google Sheet featuring various performance indicators such as clicks, conversions, impressions,... informing one about the performance per item. Get notified once the sheet got updated.

Weekly campaign performance summary and comparison last7days vs last14days

Get notified on a weekly basis about the campaign performance of the last 7 and last 14 days. This should help to stay informed about campaign performance without the need to regularly access the Google Ads account. The message can be individually enhanced by adding other relevant KPIs. Additionally, based on this flow, conditions can be added eg. only triggering the message if a certain threshold is reached.

Suggest new product titles for MC with ChatGPT

This workflow empowers you to generate innovative product titles for your Merchant Center products, harnessing the inherent characteristics within your product feed as a source of inspiration. These product titles are seamlessly exported to a Google Sheet for your review and approval, streamlining the process of enhancing your product listings within the Merchant Center. It's important to note that if any essential feed attributes required for the ChatGPT prompt are missing, the workflow will encounter an error and be marked as unsuccessful for those specific products. However, products with complete attribute data will still have their product titles readily available in the Google Sheet, ensuring efficient management regardless of any temporary challenges.

Add new title suggested by ChatGPT to MC product from Google Sheets

In this efficient process, product titles sourced from a Google Sheet are seamlessly integrated with their corresponding products within the Merchant Center. Subsequently, these titles are thoughtfully organized and archived in another Google Sheet for future reference, ensuring a streamlined approach to managing your product titles within the Merchant Center.

Update Bidding Strategies in Google Ads

Based on the performance of the last 30days and set thresholds the bid strategies of your SEARCH campaigns are updated. The thresholds currently are based on amount of conversions and costs, but can be individually adapted to your needs.

Pause bad performing keywords in Google Ads

Bad performing keywords get automatically paused once a threshold is reached.

Pause campaign (SEARCH & PMAX) if ROAS and costs threshold not met

Pause campaigns automatically if they are not performant. If the performance of the last 30 days is bad, ROAS < 5 and cost > 200.

Slack notification if campaign performance is bad (ROAS low, cost high)

A simple notification flow, which notifies users if campaign performance is bad. A bad performance can be individually specified, the current set thresholds are a ROAS < 2 and costs > 500, the comparison is based on a 14 day lookback window.

Adjust campaign budget if costs are high and ROAS threshold is met

The budget of campaigns is adjusted accordingly (the adjustment can be defined by the user) based on certain campaign performance thresholds which can also be further specified by the user.

Pause ad (SEARCH) if CPA is higher than max. CPA

With this flow ads get automatically paused if they do not meet your CPA goal.

Add negative keywords from search term report to Google Sheets (SEARCH)

Based on the search term report keywords are going to be identified which do not fulfill your set thresholds. These KWs are automatically added as a suggestion of negative terms and are added to a spreadsheet to process them further. Via an additional flow the negative KWs can be added to your Google Ads account.

Change KW match-type from broad to exact if threshold is met

Keyword matchtypes are automatically adjusted from broad to exact match if cost > 50 and conversion = 0 based on the performance of the last 14days.

Add keyword as exact match if CTR is high

Automatically add keywords with a CTR >2% as EXACT matchtype

Add keywords from search term report to Google Sheets (SEARCH)

Automatically add search terms to your adgroup as EXACT match based on specific KPIs. The KPIs hereby are set to >= 10 impressions, >= 10 clicks and >= 1 conversion. The thresholds can be adapted to your needs

Slack notification if keyword performance is bad

Get notified once your per day about bad performing keywords (ROAS < 2).

Timely scheduled switch of bid strategy

This flow changes your bid strategy of all SEARCH (or PMAX, depending on flow setting) campaigns based on specific thresholds. In this example the thresholds are conversion based but can be modified to any KPI (eg. ROAS, CPA, CTR, CR,...)

Shopify: Suggest new product description with Chat GPT 4

With this flow the power of ChatGPT is leveraged to improve your existing product descriptions. Currently the new descriptions are added to a spreadsheet, but the flow can be further modified to automatically update your product data in your shop.

Shopware 5: Suggest new product description with Chat GPT 4

With this flow the power of ChatGPT is leveraged to improve your existing product descriptions. Currently the new descriptions are added to a spreadsheet, but the flow can be further modified to automatically update your product data in your shop.

Shopify: Tag products with > 1 sale

Update your tag in Shopify to represent recent activities or other advertising relevant information. In this specific flows items with more than 1 conversion are marked as “+1sale”

Best performing product detector (last 30 days)

Receive a weekly notification about your best performing products of the last 30 days. The threshold can be individually set based on conversions, conversion value, ROAS or any other KPI and combination of KPIs.

The output is a slack notification informing the reader about the best performing products (actually their IDs) including performance information. This might look like this: “Your item with the itemId: 169411727 is amongst the best performing items with 2 conversions in the past 30 days”

Weather based optimisation

Weather data sets can be a powerful input source to make informed decisions.

If you already identified that your user behaviour differently when weather is good or bad then this flow enables you to actually take an action based on this information.

The flow collects data from a spreadsheet and compares it with eg. certain thresholds you choose (eg. if temperature drops below 0 degrees). Based on this information budget, bidding strategy or other changes can be deployed.

Labelizer for products (action)

With the labelizer flow you can categorise your products based on the recent performance. This categorisation allows you to label products via the Google Feed and assign them to the following buckets: Overindex, Underindex, Nearindex and Noindex. Based on this classification you can build campaigns within your Google Ads account and assign different budgets and goals to high and low performing products. This flow changes your custom label accordingly

Long-, Mid- and Shorttail analysis

You might have heard of the performance distribution in long-, mid- and shorttail of your products. Shorttail products are usually a small set of items generating a lot of conversions versus Longtail which features a huge range of items which only create 1 or 2 conversion. Midtail describes everything inbetween. This flow helps you to determine which items can be categorized in which buckets to better understand which items should be better kept on stock consistently and to derive other optimisation possibilites (eg. if you are interested in this you might also want to check out our labelizer flow).

Spreadsheet creation

Currently only spreadsheets created by Shopstory can be used in flows. Therefor this flow easily creates a new spreadsheet which can be linked to any flow later on. Ideally the flow is triggered manually once to create the desired sheet.

Monthly performance report including interpretation of results

Simply create a monthly report of your Search or PMax campaigns, pair your advertising performance data with Shopsystem order data and let ChatGPT interpret your results. The data is stored in a spreadsheet and can be accessed any time. Get notified per mail automatically once the report is updated.

Price competitiveness report

The price competitiveness report allows you to import the

Google Merchant Center Price Competitiveness Report

⁠

directly into Google Sheets.

The report informs you about the item ID, title, brand as well as your current price and the benchmark price of your competition. Make informed decisions and adjust product prices based on this input.

An additional flow would allow you to change and update product prices.

Access PMax Search Terms

With this flow you can create and access your PMax related search terms. To run the report you need to assign a campaign resource name to define for which campaign you want to create this report for. To identify the resource name we recommend using the “Identify campaign resource name” of our library. The PMax Search Term report delivers search terms related to your PMax campaign including performance data such as impressions, clicks and conversions. This report is a powerful source for identifying new keywords or negative keywords.

Identify campaign resource name

This report simply exports a campaign performance report to Google Sheets, giving you access to the campaign performance as well as the campaign resource name which you might want to use for other flows.

Title Optimisation (Generic approach)

The existing product titles and descriptions are used to suggest new titles via ChatGPT. These can via small modification of the flow directly be imported into the Google Merchant Center and be used to replace existing product titles. Further modifications of the flow allow the incorporation of color, size and other relevant attributes to enhance the product title accordingly.

Title Optimisation (Apparel)

The existing product titles and descriptions are used to suggest new titles via ChatGPT. These can via small modification of the flow directly be imported into the Google Merchant Center and be used to replace existing product titles.

The optimisation is based on the recommended title structure provided by Google:

⁠

Title Optimisation (Consumable)

The existing product titles and descriptions are used to suggest new titles via ChatGPT. These can via small modification of the flow directly be imported into the Google Merchant Center and be used to replace existing product titles.

The optimisation is based on the recommended title structure provided by Google:

⁠

Title Optimisation (Electronics)

The existing product titles and descriptions are used to suggest new titles via ChatGPT. These can via small modification of the flow directly be imported into the Google Merchant Center and be used to replace existing product titles.

The optimisation is based on the recommended title structure provided by Google:

⁠

Further modifications of the flow allow the incorporation of color, size and other relevant attributes to enhance the product title accordingly.

Title Optimisation (Hard Goods)

The existing product titles and descriptions are used to suggest new titles via ChatGPT. These can via small modification of the flow directly be imported into the Google Merchant Center and be used to replace existing product titles.

The optimisation is based on the recommended title structure provided by Google:

⁠

Notify about meta campaign performance

This flow notifies you every 6 hours about your campaigns’ performance, based on the KPIs that fit your business. You can be notified with either slack or mailgun.

Increase budget for high-performer meta campaigns

Increase your daily budget automatically for high performing campaigns. Here you can set multiple conditions that your campaign needs to fulfil, before the budget can be raised by either a percentage of the existing budget or a total amount (in cent).

Labelizer for products (analysis)

With the labelizer flow you can categorise your products based on the recent performance. This categorisation allows you to label products via the Google Feed and assign them to the following buckets: Overindex, Underindex, Nearindex and Noindex. Based on this classification you can build campaigns within your Google Ads account and assign different budgets and goals to high and low performing products.

Labelizer for products (analysis summary)

With the labelizer flow you can categorise your products based on the recent performance.

This categorisation allows you to label products via the Google Feed and assign them to the following buckets: Overindex, Underindex, Nearindex and Noindex.

Based on this classification you can build campaigns within your Google Ads account and assign different budgets and goals to high and low performing products.

Shopify based feed-gen for Google Shopping Ads/PMax

Create a Shopify based, basic Google Shopping data feed featuring all relevant, required attributes.

Generate meta content ideas based on high-performing keywords sourced from Google Ads

Use Google Ads performance data to identify valuable keywords to create relevant ideas for social media posts. The output of this workflow are suggestions for social media posts covering detailed explanations of what could be displayed.

META and Google Ads Campaign Performance Reporting

This is a very simple reporting flow which collects campaign performance data from Google Ads (SEARCH or PMAX) and META campaigns and writes the data regularly into a Google Sheet.

Description creation based on product information

Leverage the power of ChatGPT to create new product descriptions based on input of your existing product information. This information can feature an existing title, material, size, color, etc.

Title creation via ChatGPT and based on keyword planner data - (part 1/3)

Creating value adding titles or descriptions can be a hassle, doing so based on relevant data might be even trickier.

With this series of flows relevant keywords are isolated from current descriptions or titles. Via the Google Ads keyword planner performance statistics are created informing about search volume and competition level. High performing keywords can then be isolated and used to enrich or improve existing titles (or descriptions if the flow is adapted accordingly). Optionally these keywords can be sourced directly from your Shopsystem - use this flow as blueprint:

@Title creation via ChatGPT and based on keyword planner data - (part 1/3) (based on Shopify data)

⁠

Title creation via ChatGPT and based on keyword planner data - (part 2/3)

Creating value adding titles or descriptions can be a hassle, doing so based on relevant data might be even trickier.

With this series of flows relevant keywords are isolated from current descriptions or titles. Via the Google Ads keyword planner performance statistics are created informing about search volume and competition level. High performing keywords can then be isolated and used to enrich or improve existing titles (or descriptions if the flow is adapted accordingly). Optionally these keywords can be sourced directly from your Shopsystem - use this flow as blueprint:

@Title creation via ChatGPT and based on keyword planner data - (part 1/3) (based on Shopify data)

⁠

Title creation via ChatGPT and based on keyword planner data - (part 3/3)

Creating value adding titles or descriptions can be a hassle, doing so based on relevant data might be even trickier.

With this series of flows relevant keywords are isolated from current descriptions or titles. Via the Google Ads keyword planner performance statistics are created informing about search volume and competition level. High performing keywords can then be isolated and used to enrich or improve existing titles (or descriptions if the flow is adapted accordingly). Optionally these keywords can be sourced directly from your Shopsystem - use this flow as blueprint:

@Title creation via ChatGPT and based on keyword planner data - (part 1/3) (based on Shopify data)

⁠

Title creation via ChatGPT and based on keyword planner data - (part 1/3) (based on Shopify data)

Creating value adding titles or descriptions can be a hassle, doing so based on relevant data might be even trickier. With this series of flows relevant keywords are isolated from current descriptions or titles. Via the Google Ads keyword planner performance statistics are created informing about search volume and competition level. High performing keywords can then be isolated and used to enrich or improve existing titles (or descriptions if the flow is adapted accordingly). Optionally these keywords can be sourced directly from your Shopsystem - use this flow as blueprint: Part 1 of 3: This flow tackles the keyword isolation by leveraging the power of ChatGPT.

Add label to Meta campaigns

With this flow you can add labels to your campaigns. These labels can be e.g. “high-performer” for great campaigns or e.g. “cost-sucker” for bad campaigns. The label ID is then saved in a Google Sheets doc in order to reuse it when recalling campaigns with this label.

Recall Meta campaigns with label

With this flow you can recall the campaign performance of campaigns with a certain label. This way you can e.g. only recall high-performer or bad-performer, new ads, etc.

Exclude a specific keyword or a list of keywords in your Adgroup(s)

With this flow keywords on Adgroup level can be excluded (added as negative term). You can either set a specific keyword as implemented right now, or incorporate a list of keywords if you enrich the flow by further elements.

Meta: Notify if daily campaign budget is spent

This flow checks hourly, how much budget is remaining. If the budget remaining goes below 1, you will get a notification to increase your budget.

Meta: Notify if campaign has issues in delivery

This flow checks hourly if there are any issues with your campaign, eg. if it was not approved. If there is an issue, you will be notified in slack including an error message if it exists.

Conversion tracking issue

This flow notifies you if no conversions have been tracked fro 14 days as this might be an indicator that your conversion tracking is broken and needs to be fixed.

Content suggestion based on product data

With this flow potential blog articles are suggested based on recent performance data of your products (ads). The source for now is a Google Ads performance report but can be replaced by order reports from your Shopsystem as well. The output is shared via mail.

Writing blog posts with high-performing keywords

With this automation, entire blog posts can be written on a weekly basis via Chat GPT. The best-performing keywords via Google Ads are used for this. To identify the best-performing keywords you can set your own thresholds for various KPIs. Furthermore you can adjust the prompt to either feature more information beside keywords (eg. impressions or clicks can be added as well) or if you want to create a different outcome eg. just a draft for a content piece.

Shopstory Flow Library

Most popular flows

All available flows